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