why do i get this syntax error???

[demiurgen]

i have a link on page1 that looks like this:

<a href="page2.asp?ID=<% Response.write(oRes01.Fields.Item("ID").Value)%>"><% Response.write(oRes01("description")) %></a>

on page2.asp i have this code:

Set oRes01 = Conn.Execute("SELECT * FROM product WHERE ID = " + Replace(rs_oRes01__ColParam, "'", "''") + " ")

this gives me an error:
Syntax error (missing operator) in query expression 'ID ='.

what i want is to get the ID number from page1.asp to get in the ID number in the SQL query on page2.asp


anybody know why i get this error?
what does this code really do:
+ Replace(rs_oRes01__ColParam, "'", "''") + " ")

[TheBearMay]

Off the top of my head it looks like

 
Replace(rs_oRes01__ColParam, "'", "''")

may be returning null or spaces thus yielding an incomplete select.

[Master Shake]

Set oRes01 = Conn.Execute("SELECT * FROM product WHERE ID = " + Replace(rs_oRes01__ColParam, "'", "''") + " ")

in vbscript + is used for addition and not concatenation. change it to this and see if it works.

Set oRes01 = Conn.Execute("SELECT * FROM product WHERE ID = " & Replace(rs_oRes01__ColParam, "'", "''") & " ")

Master Shake