I recommend you capitalize all the column names in
oracle. The error could be because of the mixed case
in"newsID". Either put the newsID column in single
quotes or make it uniform.
--- Larry Juncker <[EMAIL PROTECTED]> wrote:
> Check the case of your column names. I did that
> yesterday and just because
> I had one of the column names capitalized, my query
> would not run properly.
>
> Larry Juncker
> Senior Cold Fusion Programmer
> Heartland Internet
>
> -----Original Message-----
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 02, 2000 8:29 PM
> To: CF-Talk
> 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/[email protected]/
> 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/[email protected]/
> 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.
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
