PDA

View Full Version : Select Statement Syntax

details
08-08-2002, 05:30 PM
Can this be written into a select statement?


Conn.Execute("SELECT * FROM products where catalogID="
&Request.QueryString("intCategory"))
oracleguy
08-09-2002, 12:22 AM
Conn.Execute("SELECT * FROM 'products' WHERE catalogID='" & Request.QueryString("intCategory") & "'" )


Try that.
glenngv
08-09-2002, 06:54 AM
table products should have no quotes...

Conn.Execute("SELECT * FROM products WHERE catalogID='" & Request.QueryString("intCategory") & "'" )
whammy
08-09-2002, 11:40 PM
Except for the space at the end that looks EXACTLY like my code... cool