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]
