Evik James's questions

I am brand new to URL rewriting. I am using an Apache rewriting module on IIS 7.5 (I think). Either way, I am able to do rewrites successfully, but am having trouble on a few key things.

I want this pretty url to rewrite to the this ugly url:

mydomain.com/bike/1234 (pretty) 
mydomain.com/index.cfm?Section=Bike&BikeID=1234 (ugly)

This works great with this rule:

RewriteRule ^bike/([0-9]+)$ /index.cfm?Section=Bike&BikeID$1

Issue #1

I want to be able to add a description and have it go to exactly the same place, so that the useful info is completely ignored by my application.

mydomain.com/bike/1234/a-really-great-bike (pretty and useful)
mydomain.com/index.cfm?Section=Bike&BikeID=1234

Issue #2

I need to be able to add a second or third parameter and value to the url to get extra info for the db, like this:

mydomain.com/bike/1234/5678
mydomain.com/index.cfm?Section=Bike&BikeID=1234&FeatureID=5678

This works using this rule:

RewriteRule ^bike/([0-9]+)/([0-9]+)$ /index.cfm?Section=Bike&BikeID=$1&FeatureID=$2

Again, I need to add some extra info, like in the first example:

mydomain.com/bike/1234/5678/a-really-great-bike (pretty and useful)
mydomain.com/index.cfm?Section=Bike&BikeID=1234&FeatureID=5678

So, how can I combine these rules so that I can have one or two or three parameters and any of the "useful words" are completely ignored?

I just installed SQL Server 2008 R2 and ColdFusion 9.0.1 on my Windows 7 machine for development use only.

I have ColdFusion running well and serving pages (that aren't connected to a database). I can view my databases in SQL Server Management Studio.

I successfully restored a few small databases and now I am trying to set up datasources for them through the ColdFusion Administrator. On my other machine, this was super easy. Not so much this time.

The database I just added is named "Test".

I am getting this error:

Connection verification failed for data source: Test java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect

It looks like the connection between ColdFusion and SQL Server is being refused. I know, brilliant observation, right?

On my other machine, I was able to create datasources with just the default settings, no server name, username, or password.

Any clue as to what might be the cause and how I might fix it?

I have four super small databases that I need to migrate from SQL Server 2005 on one box and move to a brand new SQL Server 2008 R2 box.

I have backed up the databases and copied them to the new machine.

Should I create the new databases and then restore the backups?

Should I restore the backups, creating them in the process?

Should I.....

What's the most reliable and easy way to set these databases up on my new machine?

I am trying to set up SQL Server 2008 R2 on my local machine for development. I set it up as well as SQL Server 2008 R2 Management Studio. When I open studio to connect to the database engine, I get this error (MONSTER is the name of my local machine):

TITLE: Connect to Server

Cannot connect to MONSTER.

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Here are the params I have

Server type: database engine
Server name: MONSTER
Authentication: Windows Authentication

Can you help?

I have a web site that uses a couple hundred domain aliases, including franchise-dallas.info, franchise-delaware.info, and detroitfranchise.info (see more below).

I have been getting ten to twenty hits per day via Google AdWords PPC. I set up a log file so that I could see the variables in the URL.

I was surprised to see that the page is getting hit about once per minute. I looked up the IPs and they are all in China.

My site has ZERO content that would be of use to anyone outside the U.S.A.

Can you tell me why my site would be getting this type of hit? Is this normal? Is this a bot?

TIME, IP, DOMAIN, PAGE
20:9, 66.249.71.138, franchise-st-petersburg.info, Why-Buy-a-Franchise
20:13, 66.249.71.21, franchise-ok.info, Frequently-Asked-Questions-About-Franchises
20:16, 66.249.71.44, franchise-dallas.info, Frequently-Asked-Questions-About-Franchises
20:20, 66.249.71.36, franchise-delaware.info, Frequently-Asked-Questions-About-Franchises
20:21, 66.249.71.136, detroitfranchise.info, What-We-Do-Free-Franchise-Advice
20:21, 66.249.71.10, philadelphiafranchise.info, Privacy-Policy
20:21, 66.249.71.144, denverfranchise.info, Franchise-Terminology
20:22, 66.249.71.59, franchise-tx.info, Get-Started-Ask-a-Franchise-Expert
20:24, 67.195.114.240, franchise-ky.info, Franchise-Terminology
20:27, 66.249.71.138, franchise-st-petersburg.info, Why-Buy-a-Franchise