Re: Help! Cold Fusion error and Oracle!

2000-10-04 Thread Dave Hannum
- 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 requi

RE: Help! Cold Fusion error and Oracle!

2000-10-04 Thread Robert Sarno
rtland 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&#

RE: Help! Cold Fusion error and Oracle!

2000-10-04 Thread Robert Sarno
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 __

Re: Help! Cold Fusion error and Oracle!

2000-10-03 Thread Deanna L. Schneider
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 refere

RE: Help! Cold Fusion error and Oracle!

2000-10-03 Thread girmawi negese
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: >

RE: Help! Cold Fusion error and Oracle!

2000-10-03 Thread Larry Juncker
: 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

Re: Help! Cold Fusion error and Oracle!

2000-10-02 Thread David Hannum
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 al

Help! Cold Fusion error and Oracle!

2000-10-02 Thread Jeff Fongemie
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, d