Jeff,
The "where" clause in your query is not correct. It should be
<CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#" >
SELECT headline, news, blurb, date_entered, newsID, live
FROM news
WHERE live = 'Yes'
ORDER by date_entered DESC
</CFQUERY>
Nathan Chen
Jeff Fongemie 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/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
>with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
