QueryString question on a number field

[ziggs]

Sorry, I'm new at this. I know how to put in a QueryString like:

SQL20 = "SELECT * FROM DB.PERSON"
SQL20 = SQL20 & WHERE TYPE = '" & Request.QueryString ("type&quot & "'"

This works fine. However, the following is based on what I believe is a number field as opposed to the above where the "type" is based on text. So, what am I doing wrong to the following (The chain is a number field I believe).

SQL20 = "SELECT * FROM DB.PERSON"
SQL20 = SQL20 & WHERE CHAIN = '" & Request.QueryString ("chain&quot & "'"

 

[wushutwist]

Take out the single quotes. Should be:

SQL20 = "SELECT * FROM DB.PERSON"
SQL20 = SQL20 & WHERE CHAIN = " & Request.QueryString ("chain")

Wushutwist