Thanks to everyone for responding so fast. Marc it was changing cfset from just ODBC_DSN to request.ODBC_DSN. Then changing all may code to use request.ODBC_DSN. At that point I took out the cfInclude lines at the top of the two offending files and they worked perfectly.
At this point I don't know why 2% of the files needed a cfinclude application.cfm when request was not used. That said now that I don't have to worry about it it will save time in debugging. Thanks again. Marc Campeau wrote: > > Could it be that you sometimes include templates in you Application.cfm and > at other times not? > > Could you have another Application.cfm in a directory below this one and > that it doesn't declare the variable? > > > > > <cfset ODBC_DSN = "MyODBCName"> > > As a suggestion you might consider using an APPLICATION scope variable for > ODBC_DSN or even a REQUEST scoped variable. > > That would be "cleaner" (that's probably debatable) than setting it to the > local scope. > > >From the Doc.: > > Application variables are designed to store application-level data. They are > a convenient place to store information that all pages of your application > might need no matter who (what client) is running that application. Using > application variables, an application could initialize itself, say, when the > first user hit any page of that application. This information could then > remain available indefinitely to all subsequent hits of any pages of that > application, by all users, thereby avoiding the overhead of repeated > initialization. > > Request variables are global to all templates, includes, custom tags used in > any given request. They are not persistent like Application variables. > > Marc > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Marc Campeau" <[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) -- 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)
