Changing Database with variables...

[JohnMitch]

Hello there. I have run into a bit of a problem and don't know how to fix it. here's the code:

Code: Select all

Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=Mydatabase"

Set recordSet =Server.CreateObject("ADODB.Recordset")
recordSet.Open "SELECT * FROM demoB" ,connectionToDatabase, 1,2

What I want to do, is to make demoB a variable so that I can see who has logged on and go to the appropriate table for that user. If anyone can help me It'd be much appreciated.

[D3mon]

Code: Select all

Dim userTable
userTable = "demoB"
recordSet.Open "SELECT * FROM " & userTable ,connectionToDatabase, 1,2

[JohnMitch]

Thank you very much D3mon. I tried everything I could think of and all I needed was a space after the "&" sign. haha. Very much appreciated.