Yes, But that didn't change anything. Is my assumption of how the
application.cfm page should work incorrect?
-----Original Message-----
From: Dave Wilson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 3:40 PM
To: [EMAIL PROTECTED]
Subject: Re: It takes CF 1 minute to close DSN
Miriam,
Have you ensured that "maintain database connections" options is UNchecked
in your odbc settings for both datasources on the server?
Dave Wilson
Internet Technology Manager,
BizNet Solutions
<Allaire Premier Partner>
Co-Founder CFUG Ireland
http://www.cfug.ie
224, Lisburn Road
Belfast BT9 6GE
Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com
email: [EMAIL PROTECTED]
----- Original Message -----
From: "Miriam Hirschman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 05, 2000 5:12 PM
Subject: RE: It takes CF 1 minute to close DSN
> 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/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.
>
----------------------------------------------------------------------------
--
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.
