RE: Help! Cold Fusion error and Oracle!
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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! Cold Fusion error and Oracle!
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 Fusion error and Oracle!
Date: Tue, 3 Oct 2000 07:40:37 -0500
MIME-Version: 1.0
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id
MHotMailBBA31FC2007840042A1ACF1F7A8C056B0; Tue Oct 03 05:44:52 2000
Received: from public.hlipublishing.com ([209.234.84.7]) by
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID#
0-54969U100L100S0V35) with ESMTP id com for
[EMAIL PROTECTED]; Tue, 3 Oct 2000 08:50:51 -0400
Received: from Larry (larry.hlipublishing.com [209.234.84.35])by
public.hlipublishing.com (Build 101 8.9.3/NT-8.9.3) with SMTP id
HAA01757for [EMAIL PROTECTED]; Tue, 03 Oct 2000 07:46:07 -0500
From [EMAIL PROTECTED] Tue Oct 03 05:46:41 2000
Message-ID: 000d01c02d37$224d0ce0$2354ead1@HEARTLAND
In-Reply-To: [EMAIL PROTECTED]
Importance: Normal
Return-Path: [EMAIL PROTECTED]
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: 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-00904: invalid column name
Data Source = "847_bib"
SQL = "SELECT headline, news, blurb, date_entered, newsID, live FROM news
WHERE (live = yes) ORDER by date_entered DESC"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (5:1) to (5:56) in the template file
D:\INETPUB\WWWROOT\HEADLINECOVER.CFM
I had an Oracle guy create the database for me, and that seems fine, buy my
Cold Fusion pages are now in error. What the heck is invalid column name?
THis is the page in question (headlinecover.cfm):
!--- query database for information ---
CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#"
SELECT headline, news, blurb, date_entered, newsID, live
FROM news
WHERE (live = yes)
ORDER by date_entered DESC
/CFQUERY
!-- If the user access this page for the first time, we set the_start
value at 1 --
CFPARAM NAME="the_start" DEFAULT="1"
!-- If the the_start is already defined,
then we had 5 to it to calculate the value of next_start --
CFIF IsDefined("the_start")
CFSET next_start = #the_start# + 3
/CFIF
!--- Output Querry ---
CFOUTPUT query="GetNews" STARTROW="#the_start#" MAXROWS="5"
bfont face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="##cc"a href="news.cfm"#headline#/a/font/bbr
font face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="black"#blurb#/fontbrbr /CFOUTPUT
bfont face="Verdana, Arial, Helvetica, sans-serif" size="1"a
href="news.cfm"More news.../a/font/b
Thanks!!!
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help! Cold Fusion error and Oracle!
- 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 No - do not use a semi-colon in your SQL statement to Oracle. You'll throw an error. Dave -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! Cold Fusion error and Oracle!
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: 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-00904: invalid column name
Data Source = "847_bib"
SQL = "SELECT headline, news, blurb, date_entered, newsID, live FROM news
WHERE (live = yes) ORDER by date_entered DESC"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (5:1) to (5:56) in the template file
D:\INETPUB\WWWROOT\HEADLINECOVER.CFM
I had an Oracle guy create the database for me, and that seems fine, buy my
Cold Fusion pages are now in error. What the heck is invalid column name?
THis is the page in question (headlinecover.cfm):
!--- query database for information ---
CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#"
SELECT headline, news, blurb, date_entered, newsID, live
FROM news
WHERE (live = yes)
ORDER by date_entered DESC
/CFQUERY
!-- If the user access this page for the first time, we set the_start
value at 1 --
CFPARAM NAME="the_start" DEFAULT="1"
!-- If the the_start is already defined,
then we had 5 to it to calculate the value of next_start --
CFIF IsDefined("the_start")
CFSET next_start = #the_start# + 3
/CFIF
!--- Output Querry ---
CFOUTPUT query="GetNews" STARTROW="#the_start#" MAXROWS="5"
bfont face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="##cc"a href="news.cfm"#headline#/a/font/bbr
font face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="black"#blurb#/fontbrbr /CFOUTPUT
bfont face="Verdana, Arial, Helvetica, sans-serif" size="1"a
href="news.cfm"More news.../a/font/b
Thanks!!!
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! Cold Fusion error and Oracle!
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 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: 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-00904: invalid column name
Data Source = "847_bib"
SQL = "SELECT headline, news, blurb, date_entered,
newsID, live FROM news
WHERE (live = yes) ORDER by date_entered DESC"
The error occurred while processing an element with
a general identifier of
(CFQUERY), occupying document position (5:1) to
(5:56) in the template file
D:\INETPUB\WWWROOT\HEADLINECOVER.CFM
I had an Oracle guy create the database for me, and
that seems fine, buy my
Cold Fusion pages are now in error. What the heck is
invalid column name?
THis is the page in question (headlinecover.cfm):
!--- query database for information ---
CFQUERY NAME="GetNews"
DATASOURCE="#application.DSN#"
SELECT headline, news, blurb, date_entered,
newsID, live
FROM news
WHERE (live = yes)
ORDER by date_entered DESC
/CFQUERY
!-- If the user access this page for the first
time, we set the_start
value at 1 --
CFPARAM NAME="the_start" DEFAULT="1"
!-- If the the_start is already defined,
then we had 5 to it to calculate the value of
next_start --
CFIF IsDefined("the_start")
CFSET next_start = #the_start# + 3
/CFIF
!--- Output Querry ---
CFOUTPUT query="GetNews" STARTROW="#the_start#"
MAXROWS="5"
bfont face="Verdana, Arial, Helvetica,
sans-serif" size="1"
color="##cc"a
href="news.cfm"#headline#/a/font/bbr
font face="Verdana, Arial, Helvetica, sans-serif"
size="1"
color="black"#blurb#/fontbrbr /CFOUTPUT
bfont face="Verdana, Arial, Helvetica,
sans-serif" size="1"a
href="news.cfm"More news.../a/font/b
Thanks!!!
--
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or
send a message to [EMAIL PROTECTED]
with 'unsubscribe' in
the body.
--
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to
[EMAIL PROTECTED] with 'unsubscribe'
in the body.
__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help! Cold Fusion error and Oracle!
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 reference the tables like so: FROMmyimportantdata.sometable Make sense? -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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
Data Source = "847_bib"
SQL = "SELECT headline, news, blurb, date_entered, newsID, live FROM news
WHERE (live = yes) ORDER by date_entered DESC"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (5:1) to (5:56) in the template file
D:\INETPUB\WWWROOT\HEADLINECOVER.CFM
I had an Oracle guy create the database for me, and that seems fine, buy my
Cold Fusion pages are now in error. What the heck is invalid column name?
THis is the page in question (headlinecover.cfm):
!--- query database for information ---
CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#"
SELECT headline, news, blurb, date_entered, newsID, live
FROM news
WHERE (live = yes)
ORDER by date_entered DESC
/CFQUERY
!-- If the user access this page for the first time, we set the_start
value at 1 --
CFPARAM NAME="the_start" DEFAULT="1"
!-- If the the_start is already defined,
then we had 5 to it to calculate the value of next_start --
CFIF IsDefined("the_start")
CFSET next_start = #the_start# + 3
/CFIF
!--- Output Querry ---
CFOUTPUT query="GetNews" STARTROW="#the_start#" MAXROWS="5"
bfont face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="##cc"a href="news.cfm"#headline#/a/font/bbr
font face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="black"#blurb#/fontbrbr /CFOUTPUT
bfont face="Verdana, Arial, Helvetica, sans-serif" size="1"a
href="news.cfm"More news.../a/font/b
Thanks!!!
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help! Cold Fusion error and Oracle!
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 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, date_entered, newsID, live FROM news
WHERE (live = yes) ORDER by date_entered DESC"
The error occurred while processing an element with a general identifier
of
(CFQUERY), occupying document position (5:1) to (5:56) in the template
file
D:\INETPUB\WWWROOT\HEADLINECOVER.CFM
I had an Oracle guy create the database for me, and that seems fine, buy
my
Cold Fusion pages are now in error. What the heck is invalid column name?
THis is the page in question (headlinecover.cfm):
!--- query database for information ---
CFQUERY NAME="GetNews" DATASOURCE="#application.DSN#"
SELECT headline, news, blurb, date_entered, newsID, live
FROM news
WHERE (live = yes)
ORDER by date_entered DESC
/CFQUERY
!-- If the user access this page for the first time, we set the_start
value at 1 --
CFPARAM NAME="the_start" DEFAULT="1"
!-- If the the_start is already defined,
then we had 5 to it to calculate the value of next_start --
CFIF IsDefined("the_start")
CFSET next_start = #the_start# + 3
/CFIF
!--- Output Querry ---
CFOUTPUT query="GetNews" STARTROW="#the_start#" MAXROWS="5"
bfont face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="##cc"a href="news.cfm"#headline#/a/font/bbr
font face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="black"#blurb#/fontbrbr /CFOUTPUT
bfont face="Verdana, Arial, Helvetica, sans-serif" size="1"a
href="news.cfm"More news.../a/font/b
Thanks!!!
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
