Query Conn...

[The Wizzard]

I have this code...

Set objList = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM List WHERE CarID = " & Request.QueryString("CarID")
objList.Open strSQL, objConection, adOpenStatic, adLockReadOnly, adCmdText

It gets the info from the querystring "CarID"

I have multiple tables, and I want to use a querystring to determine what table to connect to...

Something like this??

Set objList = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM Request.QueryString("CarID")
objList.Open strSQL, objConection, adOpenStatic, adLockReadOnly, adCmdText

[raven]

strSQL = "SELECT * FROM " & Request.QueryString("CarID") & " WHERE.........."

should work fine.

[whammy]

That seems like a strange way to do it - aren't you using a relational database? :confused:

[The Wizzard]

Well, im a strange guy... :D

Actually, im interested in the easiest way... I just assumed querystrings might be easiest...