Change this: WHERE (live = yes)
To this: WHERE live = 'yes'
Dave
----- Original Message -----
From: Jeff Fongemie <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, October 02, 2000 9:29 PM
Subject: Help! Cold Fusion error and Oracle!
> Hi all,
>
> I have a site that was built using an Access database. I'm trying to use
an
> Oracle database instead but keep getting this error message:
>
> Error Diagnostic Information
> Oracle Error Code = 904
>
> ORA-00904: invalid column name
>
>
>
> Data Source = "847_bib"
>
> SQL = "SELECT headline, news, blurb, date_entered, newsID, live FROM news
> WHERE (live = 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\HEADLINECOVER.CFM
>
> I had an Oracle guy create the database for me, and that seems fine, buy
my
> Cold Fusion pages are now in error. What the heck is invalid column name?
>
> THis is the page in question (headlinecover.cfm):
>
> <!--- query database for information --->
> <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>
>
>
> <!-- If the user access this page for the first time, we set the_start
> value at 1 -->
> <CFPARAM NAME="the_start" DEFAULT="1">
>
>
> <!-- If the the_start is already defined,
> then we had 5 to it to calculate the value of next_start -->
> <CFIF IsDefined("the_start")>
> <CFSET next_start = #the_start# + 3>
> </CFIF>
>
>
>
>
> <!--- Output Querry --->
> <CFOUTPUT query="GetNews" STARTROW="#the_start#" MAXROWS="5">
>
> <b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"
> color="##0000cc"><a href="news.cfm">#headline#</a></font></b><br>
> <font face="Verdana, Arial, Helvetica, sans-serif" size="1"
> color="black">#blurb#</font><br><br> </CFOUTPUT>
>
> <b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a
> href="news.cfm">More news...</a></font></b>
>
>
> Thanks!!!
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
