>From: "Shripad_01" <shripad_01@y...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] Re: Error in Script

>Date: Thu, 21 Feb 2002 10:38:56 +0530

>

>try to give space before and after '&'

>

>

>----- Original Message -----

>From: "arshad siddiqui" <ash_arshad@y...>

>To: "ASP Databases" <asp_databases@p...>

>Sent: Wednesday, February 20, 2002 7:05 PM

>Subject: [asp_databases] Error in Script

>

>

> > Hi,

> > I am using this code:

> > <%

> >   Dim CatID,SubCatID

> > CatID =cint( Request.QueryString ("CatID"))

> > SubCatID =cint( Request.QueryString ("SubCat"))

> >     sSQL = "SELECT

> >

>AccessoryID,CategoryID,SubCatID,AccessoryName,AccessoryDescription,Accessory

>RegularPrice,AccessorySalePrice,AccessoryStockQuantity

> > FROM Products WHERE CategoryID="& CatID &" and

> > SubCatID="& 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=1

> > and SubCatID='.

> >

> > /ramy/accessory.asp, line 179

> > ============================================

> > 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').

>

>

>

>_________________________________________________________

>

>Do You Yahoo!?

>

>Get your free @yahoo.com address at http://mail.yahoo.com

>

>

>

>




>$subst('Email.Unsub').





_________________________________________________________________

Send and receive Hotmail on your mobile device: http://mobile.msn.com