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
- 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
/cfoutput
br
/font
/cfloop
cfset designator=designator + 1
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
/td
td width="37%" align="center" valign="middle"
smallfont
face="Verdana"nbsp;#NumberFormat("#SumOfQuantity#")#
-
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
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
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
]
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
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
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
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
-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
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
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
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
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
17 matches
Mail list logo