What about:
WHERE live = YES and top = NO
My understanding is that with Boolean characters, you don't put in an
apostrophe
If your designations aren't Boolean, try:
WHERE live = 'YES' and top = 'NO'
Regards,
Derek
IT Star
Web Design, Hosting, Database Integration and Internet Marketing
http://www.itstar.co.uk/
[EMAIL PROTECTED]
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2001 15:19
To: CF-Talk
Subject: Oracle Error 936 missing expression?? Query problem?
Hello All,
I have a simple query, for an oracle database and I keep getting an
error message. What the heck is wrong with my query!
<CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#"> SELECT
headline, news, blurb, date_entered, newsID, live, top
FROM news
WHERE (live = 'YES') and (WHERE top = 'NO')
ORDER by date_entered DESC
</CFQUERY>
I've tried everything in there. It seems to be an error with syntax
and the WHERE line.
Any hints, clues or great answers are much appreciated!
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
------------------------
Internet Guns For Hire
(603) 356-0768
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists