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-04 Thread Robert Sarno
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 Fu

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 require ";" Rob

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 ORA

RE: Help! Cold Fusion error and Oracle!

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

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

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,

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 all, I have a site