This is the other page (the one that the first page links to.)
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<title>CLPTS</title>
</head>
<body bgcolor="#FFFFFF">
<cfset Count=0>
<cfset Symbol="">
<cflock timeout="30" throwontimeout="No" name="#session.urltoken#">
<cfquery name="qryGetDetail" datasource="#application.settings.dsn#"
dbtype="ODBC">
Select
Niin,
CurrentPri,
PreviousPri,
Nomenclature,
PrContractNo,
Poc,
PartNo,
Cage,
Description,
Rate,
PicWebAddress,
DetailLink
From
NewestMain
Where
niin='#url.niin#'
</cfquery>
</cflock>
<cflock timeout="30" throwontimeout="No" name="#session.urltoken#">
<cfquery name="qryGetSchedule" datasource="#application.settings.dsn#"
dbtype="ODBC">
Select
Buyyear,
Qty,
EAD,
EDD
From
Schedule
Where
Niin='#url.niin#'
</cfquery>
</cflock>
<cflock timeout="30" throwontimeout="No" name="#session.urltoken#">
<cfquery name="qryGetTotalSeca" datasource="#application.settings.dsn#"
dbtype="ODBC">
SELECT
Seca,
SumofQuantity
From
qryTotalSecas
Where
Niin='#url.niin#'
</cfquery>
</cflock>
<cflock timeout="30" throwontimeout="No" name="#session.urltoken#">
<cfquery name="qryGetNotes" datasource="#application.settings.dsn#"
dbtype="ODBC">
Select
myDate,
Details
From
Notes
Where
Niin='#url.niin#'
</cfquery>
</cflock>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="CENTER">
<strong><font face="Verdana" color="#000080"><big>CLOSED LOOP
PROCUREMENT TRACKING SYSTEM</big></font><small><small><font face="Arial"
color="#408080">
</font></small></small></strong>
</td>
<td align="CENTER">
<a href="javascript:this.history.go(-1);">
<IMG src="BackArrowBlue.gif" border=0 width=27 height=25 alt=""></a>
<br><font face="Verdana" size="-2"><b>BACK</b></font>
</td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" width="100%"
bgcolor="#FFFF00"
bordercolor="#000000" style="border-bottom: medium none">
<tr>
<td width="100%"><font
face="Verdana"><strong><small>DATA</small></strong></font></td>
</tr>
</table>
<table border="1" cellspacing="0" width="100%" bordercolor="#000000"
style="border-top: medium none; border-bottom: medium none">
<tr>
<td width="13%" align="center" valign="middle">
<font face="Arial" color="#000080"><strong><small>CURR
PRI</small></strong></font>
</td>
<td width="13%" align="center" valign="middle">
<font face="Arial" color="#000080"><strong><small>PREV
PRI</small></strong></font>
</td>
<td width="36%" align="center" valign="middle">
<font face="Arial"
color="#000080"><strong><small>NOMENCLATURE</small></strong></font>
</td>
<td width="15%" align="center" valign="middle">
<font face="Arial"
color="#000080"><strong><small>NIIN</small></strong></font>
</td>
</tr>
<cfoutput query="qryGetDetail">
<tr>
<td width="13%" align="center" valign="middle">
<small><font face="Verdana"> #CurrentPri# </font></small>
</td>
<td width="13%" align="center" valign="middle"><small>
<font face="Verdana"> #PreviousPri#</font></small>
</td>
<td width="36%" align="center" valign="middle">
<small><font face="Verdana"> #Nomenclature#</font></small>
</td>
<td width="15%" align="center" valign="middle">
<small><font face="Verdana"> #Niin#</font></small>
</td>
</tr>
</table>
<table border="1" cellspacing="0" width="100%" bordercolor="000000"
style="border-top: medium none; border-bottom: medium none">
<tr>
<td width="17%" align="center" valign="middle">
<font face="Arial" color="000080"><strong><small>POINT OF
CONTACT</small></strong></font>
</td>
<td width="17%" align="center" valign="middle">
<font face="Arial" color="000080"><strong><small>PART
NUMBER</small></strong></font></td>
<td width="4%" align="center" valign="middle">
<font face="Arial"
color="000080"><strong><small>CAGE</small></strong></font>
</td>
<td width="22%" align="center" valign="middle">
<font face="Arial" color="000080"><strong><small>PR/CONTRACT
NUMBER</small></strong></font>
</td>
</tr>
<tr>
<td width="17%" align="center" valign="middle">
<small><font face="Verdana"> #Poc#</font></small>
</td>
<td width="17%" align="center" valign="middle">
<small><font face="Verdana"> #PartNo#</font></small>
</td>
<td width="4%" align="center" valign="middle">
<small><font face="Verdana"> #Cage#</font></small>
</td>
<td width="22%" align="center" valign="middle">
<small><font face="Verdana"> #PrContractNo#</font></small>
</td>
</tr>
</table>
<cfset Picture="<img
src='http://140.229.102.109/cse/projects/#picwebaddress#' border='0'>">
<table border="1" cellpadding="0" cellspacing="0" width="100%"
bgcolor="FFFF00"
bordercolor="000000" style="border-top: medium none; border-bottom: medium
none">
<tr>
<td width="95%" valign="TOP"><font
face="Verdana"><strong><small>PROGRAM
DESCRIPTION</small></strong></font></td>
<cfif detaillink is not ""><td width="5%" valign="TOP"><a
href="http://140.229.102.109/cse/projects/#detaillink#index.html"><img
src="more-details.gif" width="100" height="16" border="0"></a></td></cfif>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" width="100%"
bordercolor="000000"
style="border-top: medium none; border-bottom: medium none" height="206">
<tr>
<td width="62%" valign="top" align="left" height="204">
<small><font face="Verdana"> #Description#</font></small>
</td>
<td width="40%" height="204" valign="middle">
<cfif #picwebaddress# is not "">
#picture#
<cfelse>
</cfif>
</td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" width="100%"
bordercolor="000000"
style="border-top: medium none; border-bottom: medium none">
<tr>
<td width="65%" bgcolor="FFFF00" valign="top">
<small><strong><font face="Verdana">
DELIVERY
SCHEDULE
</font></strong></small>
<font face="Arial" size="1" color="408080"><b>RATE:</b></font>
<font face="Verdana" size="2" color="Black">
#Rate# PER MONTH
</font></small>
</td>
</cfoutput>
<td width="34%" bgcolor="#FFFF00" valign="top"><p align="center">
<font face="Verdana"><small><strong>DELIVERY
ALLOCATION</strong></small></font>
</td>
</tr>
<tr>
<td width="65%" valign="top">
<table border="1" cellpadding="0" cellspacing="0"
width="100%" bgcolor="#FFFFFF" bordercolor="#000000"
style="border:
medium none">
<tr>
<td width="20%" align="center" valign="middle">
<font face="Arial"
color="000080"><strong><small><small>BUY YEAR
</small></small></strong></font>
</td>
<td width="20%" align="center" valign="middle">
<font face="Arial"
color="000080"><strong><small><small>
QUANTITY</small></small></strong>
</font>
</td>
<td width="30%" align="center" valign="middle">
<font face="Arial"
color="000080"><strong><small><small>
EAD</small></small></strong>
</font>
</td>
<td width="30%" align="center" valign="middle">
<font face="Arial"
color="000080"><strong><small><small>
EDD</small></small></strong>
</font>
</td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" width="100%"
bordercolor="000000"
style="border: medium none">
<cfoutput query="qryGetSchedule">
<tr>
<td width="20%" align="center" valign="middle">
<font face="Verdana"
size="2"> #BuyYear#</font>
</td>
<td width="20%" align="center" valign="middle">
<font face="Verdana"
size="2"> #Qty#</font>
</td>
<td width="30%" align="center" valign="middle">
<font face="Verdana"
size="2"> #Dateformat("#EAD#","mmm-yy")#
</font>
</td>
<td width="30%" align="center" valign="middle">
<font face="Verdana"
size="2"> #Dateformat("#EDD#","mmm-yy")#</font>
</td>
</tr>
</cfoutput>
</table>
</td>
<td width="34%" valign="top">
<table border="1" cellpadding="0" cellspacing="0" width="100%"
bordercolor="#000000"
style="border: medium none">
<tr>
<td width="63%" align="center" valign="middle"><font
face="Arial"
color="#000080">
<strong><small><small>SECA</small></small></strong></font>
</td>
<td width="37%" align="center" valign="middle"><font
face="Arial"
color="#000080">
<strong><small><small>QUANTITY</small></small></strong></font>
</td>
</tr>
<cfoutput query="qryGetTotalSeca">
<cfset Count=Count+#SumofQuantity#>
<tr>
<td width="63%" align="center" valign="middle">
<small><font
face="Verdana">
<cfswitch expression="#seca#">
<cfcase
value="AIRLANT">
<cfset
Symbol=" (L)">
</cfcase>
<cfcase value="AIRPAC">
<cfset
Symbol=" (P)">
</cfcase>
<cfcase value="CNARF">
<cfset
Symbol=" (R)">
</cfcase>
<cfcase value="NAVAIR">
<cfset
Symbol=" (N)">
</cfcase>
<cfcase value="CNATRA">
<cfset
Symbol=" (T)">
</cfcase>
<cfcase
value="NAMTRAGRU">
<cfset
Symbol=" (E)">
</cfcase>
<cfcase value="SYSCOM">
<cfset
Symbol=" (S)">
</cfcase>
<cfdefaultCase>
<cfset
Symbol="">
</cfdefaultcase>
</cfswitch>
<a
href="DeliveryDetail.cfm?niin=#niin#&seca=#seca#">#seca##Symbol#</a>
</font></small>
</td>
<td width="37%" align="center" valign="middle">
<small><font
face="Verdana"> #NumberFormat("#SumOfQuantity#")#
</font></small>
</td>
</tr>
</cfoutput>
<tr>
<td width="63%" align="center"><font
face="Arial"
color="#000080">
<small><strong><small>TOTAL</small></strong></small></font>
</td>
<td width="37%" align="center">
<!---<cfif Count gt 0>--->
<small><font
face="Verdana"> <cfoutput><b>#NumberFormat("#Count#")#</b></cfoutput>
</font></small>
<!---</cfif>--->
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" width="100%"
bgcolor="#FFFF00"
bordercolor="#000000" style="border-top: medium none; border-bottom:
medium none">
<tr>
<td width="100%"><strong><font
face="Verdana"><small>NOTES</small></font></strong></td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" width="100%"
bordercolor="#000000"
style="border-top: medium none">
<tr>
<td width="13%" align="center" valign="middle"><font face="Arial"
color="#000080">
<strong><small><small>DATE</small></small></strong></font>
</td>
<td width="87%" align="center" valign="middle"><font face="Arial"
color="#000080">
<strong><small><small>DETAILS</small></small></strong></font>
</td>
</tr>
<cfoutput query="qryGetNotes">
<tr>
<td width="13%" align="CENTER" valign="TOP"><font
face="Verdana">
<small>#Dateformat("#myDate#","mm/dd/yy")#</small></font><br><br>
</td>
<td width="87%" valign="TOP"><font face="Verdana">
<small>#Details#</small></font><br><br>
</td>
</tr>
</cfoutput>
</table>
</body>
</html>
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 10:56 AM
To: [EMAIL PROTECTED]
Subject: Re: It takes CF 1 minute to close DSN
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 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.
Hi Miriam. I'll ask again. We can't possibly guess without seeing the
code on the pages in question and maybe the URL to the site.
--
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.
