Where condition

[uconn1981]

Hi, all:

How can I use numerical variable in the Where condition? For example:

JobNo = 43

SELECT * FROM JobDatabase WHERE JobID=JobNo

The above line does not work.

Thanks,

Tim

 

[JamesLean]

Usage of variables will depend on which DBMS you're using, eg for SQL Server:

DECLARE @jobno int
SET @jobno = 43

SELECT * FROM JobDatabase WHERE JobID = @jobno

--James

 

[uconn1981]

Thanks James.

I am writing ASP pages and using VBscript. How can do I this?

Tim

 

[PHV]

JobNo = 43
strSQL = "SELECT * FROM JobDatabase WHERE JobID=" & JobNo

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244