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">
>
><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1"
>color="##0000cc"><a href="news.cfm">#headline#</a></font></b><br>
><font face="Verdana, Arial, Helvetica, sans-serif" size="1"
>color="black">#blurb#</font><br><br> </CFOUTPUT>
>
><b><font 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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
