Hi!



Make sure you use the same name as the variables you declare in the SQL 

statement:



....FROM Products WHERE CategoryID=3D"& CatID &" and

SubCatID=3D"& SubCatID &" "



Hakan



-----Ursprungligt meddelande-----

Fran: arshad siddiqui [mailto:ash_arshad@y...]

Skickat: den 20 februari 2002 14:36

Till: ASP Databases

Amne: [asp_databases] Error in Script





Hi,

I am using this code:

<%

  Dim CatID,SubCatID

	CatID =3D Request.QueryString ("CatID")

	SubCatID =3D Request.QueryString ("SubCat")

    sSQL =3D "SELECT

AccessoryID,CategoryID,SubCatID,AccessoryName,AccessoryDescription,Access

oryRegularPrice,AccessorySalePrice,AccessoryStockQuantity

FROM Products WHERE CategoryID=3D"& CatID &" and

SubCatID=3D"& SubCat &" "

%>



There is error coming in the script,its about sql but

I dont see any error in my sql statement.

The error is:

Microsoft OLE DB Provider for ODBC Drivers error

'80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error

(missing operator) in query expression 'CategoryID=3D1

and SubCatID=3D'.



/ramy/accessory.asp, line 179

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Any Idea about this

Help needed

Thanks

Regards

--Arshad--





__________________________________________________

Do You Yahoo!?

Yahoo! Sports - Coverage of the 2002 Olympic Games

http://sports.yahoo.com






$subst('Email.Unsub').