CF Installation Problems SQL Server 7.0 DTS Problem

2001-06-04 Thread Robert Sarno 

htmlDIVI installed CF 4.5 on my server that has SQL Server 7.0 and the server 
works just fine except the server DTSs do not work anymore.nbsp; It gives an error of 
co create classes not being registered.nbsp; /DIV
DIVnbsp;/DIV
DIVDoes any one have an idea of what I can do to fix this problem?/DIV
DIVnbsp;/DIV
DIVRob/DIVbr clear=allhrGet your FREE download of MSN Explorer at a 
href=http://explorer.msn.com;http://explorer.msn.com/abr/p/html

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Data transformation service

2001-03-21 Thread Robert Sarno 

Do we have any data transformation package calls with SQL Server 7.0 cold 
fusion tags ?

Rob
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

JavaScript: sending a varible to new popped up browser?

2000-12-19 Thread Robert Sarno 

I got some charts and they have discrete values to each histogram in the 
chart.  Once a person clicks on a particular histogram they should get a 
popped up menu that get data from a query in that new popped up window.  
What I need is for the parent window to send a variable to the child window.

Can anyone help my brain impediment?

Thanks in advance.

Rob

script language="JavaScript"
!-- Hide

function openWin(){

var myBars = 'directories=no, location=yes, menubar=no, status=no, 
titlebar=no, toolbar=no';
var myOptions = 'scrollbars=no, width=600, height=200, resizeable=yes';
var myFeatures = myBars + ',' + myOptions;
var suits_id = 'rs7011';

var newWin = open('test2.htm?var=' + suits_id, 'myDoc', myFeatures);



newWin.document.close();
newWin.focus();
}



// End hide ---
/script

BODY BGCOLOR="#FF"
form
bClick the following button to open a new window:/b
input type=button value="open" onClick='openWin()'
/form

/BODY
/HTML
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: schedule help

2000-12-12 Thread Robert Sarno 

Absolutely not.  There are two ways taht you can CFSCHEDULE.  One that lets 
you write the code and it will automatically make teh schedule for you on 
the admin side without have to dole out admin privileges to every developer 
and the other is to actually make it on the admin side.

I did a CFSchedule and I actually didn't like it.  My situation was one 
where I had this really long loading .cfm file and needed to get a static 
..htm version of the .cfm file.  Well, I got the page but it made a .htm page 
with all that white space that is emblematic of the processing that is going 
on the server side with .cfm file.  So the actual .htm file, neglecting the 
white space, was a 10 kb file but the file cfschedule made was 739 kb, so it 
took equally as long as the actual .cfm file.  I heard from a friend that CF 
4.5 would get rid of this white space or you can use reg script to take care 
of the .htm file with all the white space.

Good luck.

Rob


From: Scott Wood [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: schedule help
Date: Mon, 11 Dec 2000 21:20:49 -0700
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id 
MHotMailBBFF1F430066D821EECECF1F7A8CBCA04; Mon Dec 11 23:33:02 2000
Received: from houseoffusion.com ([207.31.122.140])  by 
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223  ID# 
0-54969U100L100S0V35) with ESMTP id com  for 
[EMAIL PROTECTED];  Mon, 11 Dec 2000 23:33:33 -0500
From [EMAIL PROTECTED] Mon Dec 11 23:34:21 2000
Message-id: [EMAIL PROTECTED]

I have never used Cfschedule but you should be able to simply place that
file in each directory that is being used. In doing this, the CF applicaion
server will pick it up.. Hope that helps.. (Ihave the same problem w/ my
service provider)..



G. Scott Wood
Developer
HMWeb.com
520-742-2611 Ext.135


-Original Message-
From: Jay Jennings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 9:07 PM
To: CF-Talk
Subject: schedule help


Do you have to have access to the CF Administrator in order to make use of
cfschedule? My ISP won't give me access for some strange reason (grin) 
but
looking at the docs it seems like I should just be able ti use the tag. 
Yes?

If that's so, is this code that I need to make a specific page run once
every hour?

cfschedule
   action="UPDATE"
   url="http://www.crazycanines.com/mypage.cfm"
   task="aname"
   operation="HTTPRequest"
   startdate="12/05/00"
   starttime="10:00 AM"
   interval="3600"

Thanks for any help you can give me.

  jay

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFSCHEDULE problems. PLEASE help

2000-12-06 Thread Robert Sarno 

Can someone please help me?  I am using CFSCHEDULE to make a particular .cfm 
file generate a .htm at a particular interval.  Well the schedule is working 
fine.  THe problem is I get a blank .htm file.

I am pretty sure I need to so some setting change, like rwx on unix, because 
I did very similar commands on another network that does not exist in an 
Enterprise and does not have a proxy and it worked fine.

Can someone tell me where I mey fine these file write settings??  Are they 
on the studio or admin side?

Sincerely,

Rob
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfschedule

2000-12-04 Thread Robert Sarno 

Has anyone ever use cfschedule and gotten a blank .htm page from their 
original .cfm page.  I did a simple check to see if it publishes the .cfm 
into a .htm.  Well it does, but the .htm page is blank page.

I am assuming I have the path correct because it place the .htm in the 
correct directory.  All the viewing and working with these pages will happen 
in an intranet environment.  Do I need to fiddle with the proxy and password 
stuff, even though it will not be published beyond the intranet?

Can anyone help me?

Thanks ahead of time.

Rob
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Dreamweaver Ultradev 4 - any good?

2000-11-16 Thread Robert Sarno 

He has already.  Same thing as Dreamweaver just supports color coding with 
ASP, JSP, and CF.  I prefer CF studio.

Rob


From: "Stephen M. Aylor" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Dreamweaver Ultradev 4 - any good?
Date: Wed, 15 Nov 2000 14:57:06 -0800
MIME-Version: 1.0
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id 
MHotMailBBDCC46B008CD820F3BACF1F7A8C0E9F0; Wed Nov 15 22:06:43 2000
Received: from tio.tiocom ([207.211.39.56]) by www.houseoffusion.com
   (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35)  
with ESMTP id com for [EMAIL PROTECTED];  Thu, 16 Nov 
2000 00:10:02 -0500
Received: from aia-inc.com (unverified [209.233.135.236]) by tio.tiocom 
(Rockliffe SMTPRA 3.3.1) with ESMTP id [EMAIL PROTECTED] for 
[EMAIL PROTECTED]; Wed, 15 Nov 2000 15:12:46 -0800
Received: from aiawdoc8g8f9iv [10.101.11.2] by aia-inc.com 
[10.101.11.254]with SMTP (MDaemon.v3.1.1.R)for [EMAIL PROTECTED]; 
Wed, 15 Nov 2000 15:00:03 -0800
From [EMAIL PROTECTED] Wed Nov 15 22:07:21 2000
Message-ID: 059001c04f57$60d7fa50$020b650a@aiawdoc8g8f9iv
References: 
[EMAIL PROTECTED] 
004601c04f3a$5e648f80$[EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]


I think I'll wait till after ivanopolo reviews it :-)

kidding...

Steve




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a 
message with 'unsubscribe' in the body to 
[EMAIL PROTECTED]

_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Certified ColdFusion Developers

2000-11-16 Thread Robert Sarno 

If we did not make it to the last CF Conference, how can we get certified in 
our local area.  My area is in Houston, Texas and how much is the 
certification test.

Rob


From: "Lon Lentz" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Certified ColdFusion Developers
Date: Thu, 16 Nov 2000 11:35:36 -0500
MIME-Version: 1.0
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id 
MHotMailBBDD6D21005DD82197DBCF1F7A8C0AD70; Thu Nov 16 10:06:35 2000
Received: from ns2.getlists.com ([64.244.183.74]) by www.houseoffusion.com  
 (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35)  
 with SMTP id com for [EMAIL PROTECTED];  Thu, 16 Nov 
2000 11:39:43 -0500
Received: from LPL ([172.16.5.24]) by alvion.com ( IA Mail Server Version: 
3.2.1. Build: 1084 ) ) ; Thu, 16 Nov 2000 11:32:21 -0500
From [EMAIL PROTECTED] Thu Nov 16 10:08:14 2000
Message-ID: [EMAIL PROTECTED]
In-Reply-To: 
[EMAIL PROTECTED]
Importance: Normal
Return-Path: [EMAIL PROTECTED]


   How about CF_Cert?

   If you have more than one Cf_Cert By="Allaire,Brainbench"


Lon Lentz
Applications Developer  CyberEntomologist - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210


 Just out of curiosity... since I notice that most of us who passed the
 Certification have adjusted their Sigs to say "Certified ColdFusion
 Developer", wouldn't it be easier to use an abbreviation?


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a 
message with 'unsubscribe' in the body to 
[EMAIL PROTECTED]

_
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: export excel charts - COM and CF (vs MSChart?)

2000-11-16 Thread Robert Sarno 

I don't know what this is worth since I did not implement it myself.  A 
friend told me that he created an object that allowed him to mime the HTML 
data from the CF Web Site to Excel by creating a macro through the GUI and 
then using that MACRO with CFOBJECT to create a function that can take the 
format and color features between Excel and CF program intact.

I will be trying to implement this soon, so if this is asked again and you 
all are still stuck.  I will most my implementation.

Rob


From: Rich Wild [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: export excel charts - COM and CF (vs MSChart?)
Date: Thu, 16 Nov 2000 15:16:29 -
MIME-Version: 1.0
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id 
MHotMailBBDD5999001D40042A08CF1F7A8C098A27; Thu Nov 16 08:45:59 2000
Received: from bluemountain.e-mango.com ([195.217.219.253])  by 
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223  ID# 
0-54969U100L100S0V35) with ESMTP id com  for 
[EMAIL PROTECTED]; Thu, 16 Nov 2000 10:32:33 -0500
Received: by bluemountain.e-mango.com with Internet Mail Service 
(5.5.2650.21)id W1251NWQ; Thu, 16 Nov 2000 15:16:37 -
From [EMAIL PROTECTED] Thu Nov 16 08:46:46 2000
Message-ID: 
[EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]

Mark,

I've posted the code here:

http://www.cfcomet.com/cfcomet/forum/ViewThread.cfm?ThreadID=12000E3E-9979-4
0B3-BABA4F2429E67135

hmmm - MSChart... to be honest and expose my utter lack of knowledge - I
didn't know you could - I can't seem to find an example of anyone doing it
through CFobject, but there's an asp version (which you could translate) 
at:


http://www.4guysfromrolla.com/webtech/MSChartExample.shtml

By the way, has anyone used Cold Fusion Graphlets (
http://forums.allaire.com/cfo/graphlets.htm )?? or are they the
icky-spare-5-minutes java applets that they look like? (examples weren't
working)

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
  Sent: 16 November 2000 14:16
  To: CF-Talk
  Subject: RE: export excel charts - COM and CF (vs MSChart?)
 
 
 
  Rich,
 
  I'm interested in seeing the macro, especially the gif export
  part. I am
  also wondering if people are using the MSChart object for this task,
  without Excel. Wouldn't this be less overhead than opening
  excel? Or does
  that not factor in if excel is already running on the server?
 
  Mark
 
  Mark Wimer
  American Bird Conservancy, c/o
  USGS-Patuxent Wildlife Research Center
  12100 Beech Forest Road, Laurel, MD  20708-4038
  Ph: 301-497-5596   Email: [EMAIL PROTECTED]
 
 
 
  Aha.
 
  If anyone is interested, I wrote a macro to handle the data  chart
  creation
  and gif export that runs whenever a certain cell's value changes.
 
  Through CFOBJECT I'll see if I can insert data - hence triggering the
  macro,
  exporting the gif. Then free the connection, move the file
  using cffile (or
  set the macro to save the gif in the webroot) and serve the gif using
  cfcontent or something similar.
 
  Just got to get it working now, but the theory is so far sound unless
  anyone
  can spot any glaring holes. ;)
 
  ---
  Rich Wild
  Senior Web Designer
 
  ---
  e-mango.com ltd  Tel: 01202 587 400
  Lansdowne Place  Fax: 01202 587 401
  17 Holdenhurst Road
  Bournemouth   Mailto:[EMAIL PROTECTED]
  BH8 8EW, UK  http://www.e-mango.com
  ---
  This message may contain information which is legally
  privileged and/or confidential.  If you are not the
  intended recipient, you are hereby notified that any
  unauthorised disclosure, copying, distribution or use
  of this information is strictly prohibited. Such
  notification notwithstanding, any

DHTMl CF LineGraph for FREE???

2000-10-26 Thread Robert Sarno 

Does anyone know of a free DHTML Line graph sitting around somewhere??  I do 
not want a Java graphthat takes way too long.  Thansk.

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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

CF Sessions?

2000-10-09 Thread Robert Sarno 

Can someone please point me to a great example area for CF sessions.  The 
ones in the Allaire Que books are horrible for my needs.

I am trying to use NT Authentication to authenticate persons to particular 
sessions on our corporate sight instead of a login screen.  No such luck 
that I can see an example liek that.

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.

CF Sessions Examples?

2000-10-09 Thread Robert Sarno 

Can someone please point me to a great example area for CF sessions.  The 
ones in the Allaire Que books are horrible for my needs.

I am trying to use NT Authentication to authenticate persons to particular 
sessions on our corporate sight instead of a login screen.  No such luck 
that I can see an example liek that.

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.

NT Authentication with Intranet Tool Box: Parameters for CFX_GetUser?

2000-10-05 Thread Robert Sarno 

To anyone;

I am a novice at using CFX, but I just do not understand how to use this tag 
for the stated purpose underneath.

Will CFX_Users really sync up the NT Authentication with a table that I 
designate as my Employee Table? I plan to use that sync to lead that client 
to his designated department web sites as stated  in Emp Table.  The Emp 
TAble and the NT AUth DB should be able to link together to get to the dept 
for that client.

So what would I put as action?


Rob

CFX_Users
ACTION="ADD"
USER="lsellers"
FULLNAME="Lewis A. Sellers"


CFX_Users
ACTION="CHANGEPROPERTIES"
USER="lsellers"
FULLNAME="Lewis A. Sellers"
PRIMARYGROUP="Domain Users"
DESCRIPTION="Mr. Min"
PROFILEPATH="c:\users\lsellers"
LOGONSCRIPT="login.bat"

Disabled=0
MustChangePassword=0
UserCannotChangePassword=0
PasswordNeverExpires=1
StorePasswordUsingReversibleEncryption=0
SmartcardRequired=0
PasswordNotRequired=0

LocalPath="c:\users\lsellers\"
Connect=""
To=""

AccountExpires=-1
MaxStorage=-1

CountryCode="0"
CodePage="0"

AuthorizedComputers="SUSY,SALES"


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!

2000-10-04 Thread Robert Sarno 

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!

2000-10-04 Thread Robert Sarno 

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.