Out of curiousity, what happened when you tested it by hard-coding the DSN
names rather than using application.settings.dsn?
Ken
----- Original Message -----
From: Miriam Hirschman <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 05, 2000 3:51 PM
Subject: RE: It takes CF 1 minute to close DSN
> 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.
------------------------------------------------------------------------------
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.
