Another one of those SQL syntax error

[csiwa28]

I'm getting an improper usage at my SQL statement and I don't know why. The variable "Name" is created from a query string from a previous asp page. Thanks to anyone that can help me.


SQL_query = "SELECT Product_comCompanyID FROM Products WHERE ProductTypeID =" & Request.QueryString("Name&quot

Set oRS = oConn.Execute(SQL_query)

 

[Telsa]

Is Request.QueryString("Name&quot an integer or string? Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)

 

[FengShui1998]

csiwa28,

If your Request.QueryString("Name&quot has a space in it you will need to enclose your query with single quotes.

SQL_query = "SELECT Product_comCompanyID FROM Products WHERE ProductTypeID ='" & Request.QueryString("Name&quot & "'"


Cheers,
fengshui1998

 

[avivit]

What's exactly is in the NAME?
Give us the EXACT content of it, so we can help u more.