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): SELECT headline, news, blurb, date_entered, newsID, live FROM news WHERE (live = yes) ORDER by date_entered DESC #headline# #blurb# More news... 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.
Re: Help! Cold Fusion error and Oracle!
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): > > > > SELECT headline, news, blurb, date_entered, newsID, live > FROM news > WHERE (live = yes) > > ORDER by date_entered DESC > > > > > > > > > > > > > > > > > > > color="##cc">#headline# > color="black">#blurb# > > href="news.cfm">More news... > > > 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.
RE: Help! Cold Fusion error and Oracle!
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): SELECT headline, news, blurb, date_entered, newsID, live FROM news WHERE (live = yes) ORDER by date_entered DESC #headline# #blurb# More news... 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.
RE: Help! Cold Fusion error and Oracle!
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): > > > DATASOURCE="#application.DSN#" > > SELECT headline, news, blurb, date_entered, > newsID, live > FROM news > WHERE (live = yes) > > ORDER by date_entered DESC > > > > > > > > > > > > > > > > > MAXROWS="5"> > > color="##cc"> href="news.cfm">#headline# > size="1" > color="black">#blurb# > > href="news.cfm">More news... > > > 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. __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- 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.
Re: Help! Cold Fusion error and Oracle!
Also, be sure that if you're using a "user" that has been granted access to the data that you precede the table names with the appropriate user name. For example: Your tables are in "myimportantdata." You're accessing your tables through "webviewofimportantdata." Your queries would need to reference the tables like so: FROMmyimportantdata.sometable Make sense? -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- 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.
RE: Help! Cold Fusion error and Oracle!
Also when porting to ORacle from Access, you need to keep in mind syntax. I am not sure which way it goes, but soem SQL statements require ";" semicolons. I thought case doesn't make a difference in SQL. I hope it helps. Good luck. Rob _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- 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.
RE: Help! Cold Fusion error and Oracle!
I am sorry if I lead astray with that message, but maybe you need a single quote around the live ='yes'. Since it is a string you are looking for. ROb >From: "Larry Juncker" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Help! Cold Fusion error and Oracle! >Date: Tue, 3 Oct 2000 07:40:37 -0500 >MIME-Version: 1.0 >Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id >MHotMailBBA31FC2007840042A1ACF1F7A8C056B0; Tue Oct 03 05:44:52 2000 >Received: from public.hlipublishing.com ([209.234.84.7]) by >www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# >0-54969U100L100S0V35) with ESMTP id com for ><[EMAIL PROTECTED]>; Tue, 3 Oct 2000 08:50:51 -0400 >Received: from Larry (larry.hlipublishing.com [209.234.84.35])by >public.hlipublishing.com (Build 101 8.9.3/NT-8.9.3) with SMTP id >HAA01757for <[EMAIL PROTECTED]>; Tue, 03 Oct 2000 07:46:07 -0500 >From [EMAIL PROTECTED] Tue Oct 03 05:46:41 2000 >Message-ID: <000d01c02d37$224d0ce0$2354ead1@HEARTLAND> >In-Reply-To: <[EMAIL PROTECTED]> >Importance: Normal >Return-Path: [EMAIL PROTECTED] > >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): > > > >SELECT headline, news, blurb, date_entered, newsID, live >FROM news >WHERE (live = yes) > >ORDER by date_entered DESC > > > > > > > > > > > > > > > > > > >color="##cc">#headline# >color="black">#blurb# > >href="news.cfm">More news... > > >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. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- 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.
Re: Help! Cold Fusion error and Oracle!
- Original Message - From: "Robert Sarno" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 04, 2000 9:44 AM Subject: RE: Help! Cold Fusion error and Oracle! >am not sure which way it goes, but soem SQL statements require ";" >Rob No - do not use a semi-colon in your SQL statement to Oracle. You'll throw an error. Dave -- 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.
