sql syntax error 2

[ringadeal]

What is wrong with my syntax that is bringing the following error message?:

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

[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression '(productid_img = 197 OR ProductFam=1) OR subfam=10 AND (ColoursAtt1 <> ") ORDER BY sort_img_prd DESC'.

 

[PHV]

Replace this:
[tt]"[/tt]
with this:
[tt]''[/tt]

Furthermore, I'd suggest you to carefully use parentheses when mixing OR & AND operators

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kjv1611]

ringadeal ,

Did PHV's suggestion fix your problem? Please update with your situation.

--

"If to err is human, then I must be some kind of human!" -Me

 

[ringadeal]

thanks for your concern. Yes, this was the solution!!!!