Session variable in SELECT statement?

[targa]

What am I doing wrong here?

This works:
SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1'

But when I try to add a session value in the query I get invalid syntax

SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1' AND StatID = "
& session("Dealer_ID") & ""

Ive tried tons of variables but cant seem to get it right.

TIA!

[Ken Schaefer]

a) What is the *exact* error?

b) Number 1 SQL troubleshooting tip:

<%
strSQL = _
"SELECT Count(ID) AS MyCount " & _
"FROM mytable " & _
"WHERE Status = '1' " & _
"AND StatID = " & session("Dealer_ID")

Response.Write(strSQL)
Response.End
%>

so you can see what you're actually sending to the database.

Cheers
Ken



"targa" <targa1@alltel.net> wrote in message
news:%23I0dkUafDHA.1736@TK2MSFTNGP12.phx.gbl...
: What am I doing wrong here?
:
: This works:
: SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1'
:
: But when I try to add a session value in the query I get invalid syntax
:
: SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1' AND StatID =
"
: & session("Dealer_ID") & ""
:
: Ive tried tons of variables but cant seem to get it right.
:
: TIA!
:
:
:

[Bullschmidt]

Perhaps change this:
SELECT Count(ID) AS MyCount FROM mytable WHERE Status = '1' AND StatID
= "
& session("Dealer_ID") & ""

To be more like this instead:
SELECT Count(ID) AS MyCount FROM mytable WHERE (Status = '1') AND
(StatID = '"
& session("Dealer_ID") & "')"

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!