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