Sage advice, indeed. :-) Sometimes it IS the little things! /charlie
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Karl Zarudny Sent: Friday, March 01, 2002 3:58 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] Application.cfm question When you say bombs, what is the error that's kicked back? Where does it bomb?.... during the execution of the query or on spitting out the results, or somewhere in between? Are you actually naming the var "ODBC_DSN" in which case have you checked for typos. My suggestion would be to compare the working file and one that bombs and look for differences that could be causing your errors. It's amazing how easy it is to miss the smallest typo which causes catastrophic results.... I do it all the time :-) Hope this helps. Karl > From: Glenn Shukster <[EMAIL PROTECTED]> > Organization: Logic Fundamentals Inc. > Reply-To: [EMAIL PROTECTED] > Date: Fri, 01 Mar 2002 15:03:14 -0500 > To: cfTalk <[EMAIL PROTECTED]> > Subject: [CFTALKTor] Application.cfm question > > I thought Application.cfm was included in all files automatically. > > In some files the below line will bomb > <cfquery name="qryName" datasource="#ODBC_DSN#"> > ... > > In Application.cfm > <cfset ODBC_DSN = "MyODBCName"> > > In many of the cfm files this works perfectly without doing anything. > In a few others I have to do a cfinclude of the application.cfm or it > bombs. > Why? > -- > Cheers > Glenn Shukster (Logic Fundamentals Inc.) Thornhill, Ont. Canada > Phone:(905)771-6458 Fax:(905)771-6819 www.logicfundamentals.com > President of TDUG www.tdug.com > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: Glenn Shukster <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Karl Zarudny <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "charles arehart" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
