It takes CF 1 minute to close DSN

2000-09-05 Thread Miriam Hirschman
I posted this question over the weekend, but I don't have a solution so I am posting it again. I have a page that connects to one DSN1 and it has a link that calls a page which connects to another DSN2. Now I get an error. CF is looking in DSN1 for a table that is in DSN2. If I wait a minute

Re: It takes CF 1 minute to close DSN

2000-09-05 Thread Ken Wilson
- Original Message - From: Miriam Hirschman [EMAIL PROTECTED] To: CF Forum [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 8:44 AM Subject: It takes CF 1 minute to close DSN I posted this question over the weekend, but I don't have a solution so I am posting it again. I have a page

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Miriam Hirschman
/cfoutput br /font /cfloop cfset designator=designator + 1

Re: It takes CF 1 minute to close DSN

2000-09-05 Thread Bud
On 9/5/00, Miriam Hirschman penned: I posted this question over the weekend, but I don't have a solution so I am posting it again. I have a page that connects to one DSN1 and it has a link that calls a page which connects to another DSN2. Now I get an error. CF is looking in DSN1 for a table

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Miriam Hirschman
/td td width="37%" align="center" valign="middle" smallfont face="Verdana"nbsp;#NumberFormat("#SumOfQuantity#")#

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread David E. Crawford
- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 15:13 To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN This is the other page (the one that the first page links to.) html head meta name="GENERATOR" co

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Miriam Hirschman
AM To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN This is a multi-part message in MIME format. --=_NextPart_000_0257_01C0174C.9993FDA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: It takes CF 1 minute to close DSNW

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Bud
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

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Miriam Hirschman
] 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

Re: It takes CF 1 minute to close DSN

2000-09-05 Thread Dave Wilson
ad 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 minu

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Miriam Hirschman
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

Re: It takes CF 1 minute to close DSN

2000-09-05 Thread Ken Wilson
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

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Miriam Hirschman
-Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 4:42 PM To: [EMAIL PROTECTED] Subject: Re: It takes CF 1 minute to close DSN Out of curiousity, what happened when you tested it by hard-coding the DSN names rather than using

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Bud
On 9/5/00, Miriam Hirschman penned: Each page is part of an application. There are two application, which are it two separate folders. They each have their own application.cfm page which refers to their own DSN. Just a hunch. You DO have the application name different in the cfapplication tag

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Bud
On 9/5/00, Miriam Hirschman penned: I thought that the application.cfm page is called before each page in that directory. Well, that's why we needed to see some code. :-D No telling what some folks may do. So why doesn't the variable get updated before the page loads. Also, I've used this

RE: It takes CF 1 minute to close DSN

2000-09-05 Thread Bud
On 9/5/00, Miriam Hirschman penned: It worked on my computer, I didn't test it on the real server yet but I think it would work there too. Is my method of using #application.settings.dsn# incorrect? Before I upload the changes, I wanted to know if it makes sense that that is what's causing the

RE: Thanks Bud!!!....It takes CF 1 minute to close DSN

2000-09-05 Thread Miriam Hirschman
ber 05, 2000 6:39 PM To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN On 9/5/00, Miriam Hirschman penned: It worked on my computer, I didn't test it on the real server yet but I think it would work there too. Is my method of using #application.settings.dsn# incorrect? Before