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, "'", "''") + " ")