I thought that the application.cfm page is called before each page in that
directory. So why doesn't the variable get updated before the page loads.
Also, I've used this code before in other applications without a problem.
I'm not sure I understand why this method is giving me an error now. In a
CF article I read, it said that it is better not to hard code the DSN name,
because it makes your code hard to maintain. Please explain.
Thanks so much for your time.
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 12:01 PM
To: [EMAIL PROTECTED]
Subject: RE: It takes CF 1 minute to close DSN
On 9/5/00, Miriam Hirschman penned:
><cfquery name="qryGetProgram" datasource="#Application.settings.dsn#"
>dbtype="ODBC">
Where are you setting application.settings.dsn? What are you using
for the datasource name on the second page? If you are using
application.settings.dsn as the datasource name for both queries, and
if that is supposed to change dynamically, depending on which page
you are accessing (which by the way, would probably be a bad use of
application variables) and it's not changing until AFTER you access
the second query, then that would explain why it doesn't access the
correct datasource until you click the 2nd time, AFTER the
application variable is updated.
Try entering the datasource names manually in both queries and see
what happens.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
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/[email protected]/
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.
