Topic awaiting preservation: querystring variable (Page 1 of 1)

I am calling a variable from one page to another: "lookup.asp?article=ps1" using request.querystring

article1 = request.querystring("article")
How can I use article1's value in the select string: ["select * from table where id= "value of article 1"]

any help would be appreciated.
Thanks
Enas

"SELECT * FROM table WHERE ID=" & article1 & ""

should work, I think, though I often have problems getting the "'s right.

DIdn't work, it says too few paramaters.

what language are you using?

tis' asp pugz. (it's in that query string but not very clear)



.:[ Be Bert. Be Ernie. Just be. ]:.

I think

article1 = request.querystring("article")

strSQL = "select * from table where id='" & article1 & "'"

should do you if the article1 variable is a string rather than a numeric value

hth
I:.

ID is almost always a numeric value though so I'd think:

article1 = request.querystring("article")

strSQL = "select * from table where id=" & article1 & ";"

-dk

- can't decide? have another drink.

Thanks for the help guys.
The article1 was a string. IT's for a help database for my school. I have a ton of naive faculty that do the dumbest things t otheir computers. In either case, I got it working thanks to your help.
IT's much appreciated.
Ensa