- 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
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
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
__
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
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:
>
: 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
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
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
8 matches
Mail list logo