SQL Statement probleme

[hifive]

Got a problem with this staement:

sqlString = "SELECT product_id,product_picture,product,product_briefdesc" &_
"FROM Prod_Products WHERE Product_category='" & cat & "' "&_
"AND product_status=1 " &_
"ORDER BY Product "

I GAVE ME THIS ERROR (SORRY IT'S FRENCH)

Microsoft OLE DB Provider for ODBC Drivers erreur '80040e14'

[Microsoft][Pilote ODBC Microsoft Access] Erreur de syntaxe (opérateur absent) dans l'expression 'product_briefdescFROM Prod_Products WHERE Product_category='Home' AND product_status=1 ORDER BY Product'.

/ProductList.asp, ligne 9

CAN you help me

 

[jballum]

Space between product_briefdesc and FROM needed?

JB

 

[hifive]

First thank's for your response!
i knew that but how to do it ???

Hifive

 

[TomSark]

Add the space at the end of the first string:

sqlString = "SELECT product_id,product_picture,product,product_briefdesc " &_

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[hifive]

Hi tomsark and thank's for your interest
i tried this too but that gave me this error message ;
********************************************************
Microsoft OLE DB Provider for ODBC Drivers erreur '80040e10'

[Microsoft][Pilote ODBC Microsoft Access] Trop peu de paramètres. 1 attendu.

/ProductList.asp, line 9

FRENCH TRANSLATION****
trop peu de parametre = Not enough parameters
1 attendus = 1 expected