change is YES to = 'Yes' also oracle is case sensitive "Jeff Fongemie" <[EMAIL PROTECTED]> wrote: I'm missing something here. I have an Oracle database. A column named LIVE have a type of varchar2(3), with possible values of YES or NO. I have a simple query where I am attempting to get all records where LIVE is YES. Sounds easy right?? Why does this give me an error? <CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#" > SELECT headline, news, blurb, date_entered, newsID, live FROM news WHERE live is YES ORDER by date_entered DESC </CFQUERY> This is the error: Error Diagnostic Information Oracle Error Code = 908 ORA-00908: missing NULL keyword Data Source = "velo" SQL = "SELECT headline, news, blurb, date_entered, newsID, live FROM news WHERE live is YES ORDER by date_entered DESC" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:56) in the template file D:\INETPUB\WWWROOT\CYCLES\HEADLINECOVER.CFM The specific sequence of files included or processed is: D:\INETPUB\WWWROOT\CYCLES\INDEX.CFM D:\INETPUB\WWWROOT\CYCLES\HEADLINECOVER.CFM CFInclude. What's going on with NULL keyword?? If I use NULL or NOT NULL I get all or none of the records! Jeff F. ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
