Printable View
I'm having a problem when adding a variable to my SQL.
This worked.
strSQL = "Select * from Events WHERE UserID="&uID
This gave me an error.
strSQL = "Select * from Events WHERE UserID="&uID&"ORDER BY EventTime"
I tried many variations but came up with bad bad stuff.
Maybe someone can suggest a good SQL tutorial?
I presume you are using VB/VBScript to perform the DB call?
On the first glance i notice a space missing before the order by clause:
strSQL = "Select * from Events WHERE UserID="&uID&" ORDER BY EventTime"
What data type is the field UserID? If it is a char or varchar then you should enclose the variable in single quotes:
strSQL = "Select * from Events WHERE UserID='" & uID & "' ORDER BY EventTime"
If this does not help, please post the detailed error message you are getting. I am assuming you are getting an OLE DB / ODBC error.
andi_g69 is correct about the spaces, but I wanted to add in that you will also get an error if uid is null.
When in doubt in situations like this, have your program or ASP page output the query for you and see if it looks right. Try copying the resulting query into Query Analyzer or whatever db you're using and execute it there. You may get a better error that way.