OK, I'm not sure what code you want to see, but here is the code for the
page that has a link to anothere page. If this is not what you wanted plese
let me know. Thanks for your help.
<html>
<head>
<title>Common Support Eqiuipment</title>
</head>
<cfset designator=1>
<body bgcolor="White">
<cflock timeout="30" throwontimeout="No" name="#session.urltoken#">
<cfquery name="qryGetProgram" datasource="#Application.settings.dsn#"
dbtype="ODBC">
SELECT
Distinct Program
FROM
Equipment
</cfquery>
</cflock>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="Navy">
<td width="25%"><b><font face="Arial"
color="White">PROGRAM</font></b></td>
<td width="75%"><b><font face="Arial" color="White">
<img src="Images/blank.gif" width=35 height=12 border=0 alt="">
<img src="Images/blank.gif" width=35 height=12 border=0 alt="">
<img src="Images/blank.gif" width=35 height=12 border=0>
<img src="Images/blank.gif" width=35 height=12 border=0>
EQUIPMENT</font></b>
</td>
</tr>
<cfloop query="qryGetProgram">
<cflock timeout="30" throwontimeout="No" name="#session.urltoken#">
<cfquery name="qryGetProjects" datasource="#Application.settings.dsn#"
dbtype="ODBC">
SELECT
*
FROM
Equipment
WHERE
program='#qrygetprogram.program#'
ORDER BY Nomenclature asc
</cfquery>
</cflock>
<cfif designator Mod 2>
<cfset color="FFFFFF">
<cfelse>
<cfset color="CCCCFF">
</cfif>
<tr bgcolor="<cfoutput>#color#</cfoutput>">
<td width="25%" valign="TOP"><cfoutput><font face="Verdana"
size="1">#qryGetProgram.Program#</font></cfoutput></td>
<td width="75%" valign="TOP">
<cfloop query="qryGetProjects">
<cfset
strCLPTS="../clpts/CopyofClpts/Detail1.cfm?Niin=" & #Niin#>
<font face="Verdana" size="1">
<cfif #clpts# is not "">
<cfoutput><a href="#strclpts#"
target="_top"><img
src="Images/clpts.gif" width=35 height=12 border=0></a></cfoutput>
<cfelse>
<img src="Images/blank.gif"
width=35 height=12 border=0>
</cfif>
</cfoutput>
<br>
</font>
</cfloop>
<cfset designator=designator + 1>
</td>
</cfloop>
</tr>
</table>
</body>
</html>
-----Original Message-----
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 10:15 AM
To: [EMAIL PROTECTED]
Subject: Re: It takes CF 1 minute to close DSN
Have you spoken to the Admin of the server about this yet? I routinely do
what you describe without fail which leads me to think it must be something
other than CF that is causing the problem.
Or perhaps posting a bit of your code would help us to identify if there is
a CF code problem.
Ken
----- 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 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 then CF
seems to let go of DSN1 and I don't get an error. I am using CF 4.0. Any
help would be appreciated.
Thanks,
---miriam
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/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.
------------------------------------------------------------------------------
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.
