NEED TO QUERY AN INTEGER IN AN SQL COMMAND IN ASP

[aviles22]

I AM EXPERIENCED IN ASP AND SQL QUERYING BUT THIS LITTLE PROBLEM IS GETTING TO MY HEAD!

I AM USING THIS CODE ON AN ASP PAGE!

HOW CAN I DO THIS!

TempID = 18
oRS.Open "SELECT * FROM Employees Where ID = TempID

I'VE TRIED '" &TempId& "'
among others please give me the correct format, Thanks!

 

[link9]

depends on what format the data is in the database -- your title indicates it's an integer, but you are trying to use the ' tick marks to set it off like it was a string.

You were on the right track with the & operator -- you might take it a step further by placing the SQL statement into a variable first, and then using that to open the recordset --

sqlString = "SELECT * FROM Employees Where ID = " & TempID
oRS.Open sqlString

don't use the ticks if it's an integer (or number) value in the database --

hope it helps!
Paul Prewett

 

[Swany]

tempid = 18
oRS.open "select * from employees where id=" & tempid

if tempid is a varchar in the table then
oRS.open "select * from employees where id='" & tempid & "'"