Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

syntax error

Status
Not open for further replies.
ringadeal

ringadeal

Technical User
Jan 16, 2008
67
US
What is wrong with my syntax that is bringing the following error message?:
Code: 
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'.

 
Sort by date Sort by votes
(ColoursAtt1 <> ")

possibly should be

(ColoursAtt1 <> '')

That is, should be two single-quotes, not one double-quote
 
Upvote 0 Downvote
Hi,
also, tho not a syntax issue, be careful when mixing ANDs and ORs to be sure your parens correctly control the order of interpretation.




[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Krus1972
  • Locked
  • Question
msxml3.dll error '80072f7d' - An error occurred in the secure Channel support
Replies
7
Views
368
Krus1972
Krus1972
leifoet
  • Locked
  • Question
Using date picker gives an error message, only at application start
Replies
1
Views
211
MarkSweetland
MarkSweetland
chikwendu
  • Locked
  • Question
OraOLEDB error '80040e4b'
Replies
1
Views
363
xwb
xwb
jd.ford1
  • Locked
  • Question
Need help with syntax
Replies
10
Views
175
jd.ford1
jd.ford1
leifoet
  • Locked
  • Question
Selection query - looking for the correct syntax
Replies
8
Views
135
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top