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.
-----Original Message-----
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 11:19 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 DSNWell, to my eye, it looks like you are
using "#application.settings.dsn#" in both pages, so unless the tables in
question are in the that datasource you are going to have some issues. Have
you tried testing with hard coded datasource names instead of looking in the
application scope to see if there is a difference in behavior?
DC
-----Original Message-----
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" 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.
------=_NextPart_000_0257_01C0174C.9993FDA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: It takes CF 1 minute to close DSN</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D865381715-05092000>Well,=20
to my eye, it looks like you are using "#application.settings.dsn#" in =
both=20
pages, so unless the tables in question are in the that datasource you =
are going=20
to have some issues. Have you tried testing with hard coded =
datasource=20
names instead of looking in the application scope to see if there is a=20
difference in behavior?</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D865381715-05092000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D865381715-05092000>DC</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D865381715-05092000></SPAN></FONT> </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Miriam Hirschman=20
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Tuesday, September =
05, 2000=20
15:13<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Subject:</B> RE: =
It takes=20
CF 1 minute to close DSN<BR><BR></DIV></FONT>
<P><FONT size=3D2>This is the other page (the one that the first page =
links=20
to.)</FONT> </P>
<P><FONT size=3D2><html></FONT> </P>
<P><FONT size=3D2><head></FONT> <BR><FONT size=3D2><meta =
name=3D"GENERATOR"=20
content=3D"Microsoft FrontPage 3.0"></FONT> <BR><FONT=20
size=3D2><title>CLPTS</title></FONT> <BR><FONT=20
size=3D2></head></FONT> </P>
<P><FONT size=3D2><body bgcolor=3D"#FFFFFF"></FONT> <BR><FONT=20
size=3D2><cfset Count=3D0></FONT> <BR><FONT size=3D2><cfset=20
Symbol=3D""></FONT> <BR><FONT size=3D2><cflock timeout=3D"30"=20
throwontimeout=3D"No" name=3D"#session.urltoken#"></FONT> <BR><FONT =
size=3D2><cfquery name=3D"qryGetDetail"=20
datasource=3D"#application.settings.dsn#"</FONT> <BR><FONT=20
size=3D2>dbtype=3D"ODBC"></FONT> <BR><FONT size=3D2>Select</FONT>=20
<BR> <FONT =
size=3D2>Niin,</FONT>=20
<BR> <FONT =
size=3D2>CurrentPri,</FONT>=20
<BR> <FONT=20
size=3D2>PreviousPri,</FONT> =
<BR> =20
<FONT size=3D2>Nomenclature,</FONT>=20
<BR> <FONT=20
size=3D2>PrContractNo,</FONT> =
<BR> =20
<FONT size=3D2>Poc,</FONT> =
<BR> <FONT=20
size=3D2>PartNo,</FONT> <BR> =
<FONT=20
size=3D2>Cage,</FONT> <BR> =
<FONT=20
size=3D2>Description,</FONT> =
<BR> =20
<FONT size=3D2>Rate,</FONT> =
<BR> <FONT=20
size=3D2>PicWebAddress,</FONT> =
<BR> =20
<FONT size=3D2>DetailLink</FONT> <BR><FONT size=3D2>From</FONT>=20
<BR> <FONT =
size=3D2>NewestMain</FONT>=20
<BR><FONT size=3D2>Where</FONT> =
<BR> =20
<FONT size=3D2>niin=3D'#url.niin#'</FONT> <BR><FONT =
size=3D2></cfquery></FONT>=20
<BR><FONT size=3D2></cflock></FONT> <BR><FONT =
size=3D2><cflock=20
timeout=3D"30" throwontimeout=3D"No" =
name=3D"#session.urltoken#"></FONT>=20
<BR><FONT size=3D2><cfquery name=3D"qryGetSchedule"=20
datasource=3D"#application.settings.dsn#"</FONT> <BR><FONT=20
size=3D2>dbtype=3D"ODBC"></FONT> <BR><FONT size=3D2>Select</FONT>=20
<BR> <FONT =
size=3D2>Buyyear,</FONT>=20
<BR> <FONT =
size=3D2>Qty,</FONT>=20
<BR> <FONT =
size=3D2>EAD,</FONT>=20
<BR> <FONT =
size=3D2>EDD</FONT>=20
<BR><FONT size=3D2>From</FONT> =
<BR> =20
<FONT size=3D2>Schedule</FONT> <BR><FONT size=3D2>Where</FONT>=20
<BR> <FONT=20
size=3D2>Niin=3D'#url.niin#'</FONT> <BR><FONT =
size=3D2></cfquery></FONT>=20
<BR><FONT size=3D2></cflock></FONT> <BR><FONT =
size=3D2><cflock=20
timeout=3D"30" throwontimeout=3D"No" =
name=3D"#session.urltoken#"></FONT>=20
<BR><FONT size=3D2><cfquery name=3D"qryGetTotalSeca"=20
datasource=3D"#application.settings.dsn#"</FONT> <BR><FONT=20
size=3D2>dbtype=3D"ODBC"></FONT> <BR><FONT size=3D2>SELECT</FONT>=20
<BR> <FONT =
size=3D2>Seca,</FONT>=20
<BR> <FONT=20
size=3D2>SumofQuantity</FONT> <BR><FONT size=3D2>From</FONT>=20
<BR> <FONT=20
size=3D2>qryTotalSecas</FONT> <BR><FONT size=3D2>Where</FONT>=20
<BR> <FONT=20
size=3D2>Niin=3D'#url.niin#'</FONT> <BR><FONT =
size=3D2></cfquery></FONT>=20
<BR><FONT size=3D2></cflock></FONT> <BR><FONT =
size=3D2><cflock=20
timeout=3D"30" throwontimeout=3D"No" =
name=3D"#session.urltoken#"></FONT>=20
<BR><FONT size=3D2><cfquery name=3D"qryGetNotes"=20
datasource=3D"#application.settings.dsn#"</FONT> <BR><FONT=20
size=3D2>dbtype=3D"ODBC"></FONT> <BR><FONT size=3D2>Select</FONT>=20
<BR> <FONT =
size=3D2>myDate,</FONT>=20
<BR> <FONT =
size=3D2>Details</FONT>=20
<BR><FONT size=3D2>From</FONT> =
<BR> =20
<FONT size=3D2>Notes</FONT> <BR><FONT size=3D2>Where</FONT>=20
<BR> <FONT=20
size=3D2>Niin=3D'#url.niin#'</FONT> <BR><FONT =
size=3D2></cfquery></FONT>=20
<BR><FONT size=3D2></cflock></FONT> <BR><FONT size=3D2><table =
width=3D"100%" border=3D"0" cellspacing=3D"0" =
cellpadding=3D"0"></FONT> <BR><FONT=20
size=3D2><tr></FONT> =
<BR> <FONT=20
size=3D2><td align=3D"CENTER"></FONT>=20
<BR> <FONT=20
size=3D2><strong><font face=3D"Verdana"=20
color=3D"#000080"><big>CLOSED LOOP</FONT>=20
<BR> <FONT =
size=3D2>PROCUREMENT=20
TRACKING =
SYSTEM</big></font><small><small><font=20
face=3D"Arial"</FONT> <BR><FONT size=3D2>color=3D"#408080"></FONT>=20
<BR> <FONT=20
=
size=3D2></font></small></small></strong></FONT> =
<BR><FONT size=3D2></td></FONT> <BR><FONT size=3D2><td=20
align=3D"CENTER"></FONT> =
<BR> <FONT=20
size=3D2><a href=3D"javascript:this.history.go(-1);"></FONT>=20
<BR> =20
<FONT size=3D2><IMG=20
src=3D"BackArrowBlue.gif" border=3D0 width=3D27 height=3D25=20
alt=3D""></a></FONT> =
<BR> =20
<FONT =
size=3D2><br><font=20
face=3D"Verdana" =
size=3D"-2"><b>BACK</b></font></FONT>=20
<BR><FONT size=3D2></td></FONT> <BR><FONT =
size=3D2></tr></FONT> </P>
<P><FONT size=3D2></table></FONT> <BR><FONT size=3D2><table =
border=3D"1"=20
cellpadding=3D"0" cellspacing=3D"0" width=3D"100%"</FONT> <BR><FONT=20
size=3D2>bgcolor=3D"#FFFF00"</FONT> <BR><FONT =
size=3D2>bordercolor=3D"#000000"=20
style=3D"border-bottom: medium none"></FONT> <BR><FONT =
size=3D2> =20
<tr></FONT> <BR><FONT size=3D2> <td=20
width=3D"100%"><font</FONT> <BR><FONT=20
=
size=3D2>face=3D"Verdana"><strong><small>DATA</small>=
;</strong></font></td></FONT>=20
<BR><FONT size=3D2> </tr></FONT> <BR><FONT=20
size=3D2></table></FONT> </P>
<P><FONT size=3D2><table border=3D"1" cellspacing=3D"0" =
width=3D"100%"=20
bordercolor=3D"#000000"</FONT> =
<BR> =20
<FONT size=3D2>style=3D"border-top: medium none; border-bottom: medium =
none"></FONT> <BR><FONT =
size=3D2> =20
<tr></FONT> <BR><FONT size=3D2> =
=20
<td width=3D"13%" align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"#000080"><strong><small>CURR</FONT> <BR><FONT=20
size=3D2>PRI</small></strong></font></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"13%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"#000080"><strong><small>PREV</FONT> <BR><FONT=20
size=3D2>PRI</small></strong></font></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"36%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT size=3D2><font=20
face=3D"Arial"</FONT> <BR><FONT=20
=
size=3D2>color=3D"#000080"><strong><small>NOMENCLATURE<=
/small></strong></font></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"15%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT size=3D2><font=20
face=3D"Arial"</FONT> <BR><FONT=20
=
size=3D2>color=3D"#000080"><strong><small>NIIN</small&g=
t;</strong></font></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =
</tr></FONT>=20
<BR><FONT size=3D2> <cfoutput=20
query=3D"qryGetDetail"></FONT> <BR><FONT size=3D2> =20
<tr></FONT> <BR><FONT=20
size=3D2> <td width=3D"13%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
<FONT =
size=3D2><small><font=20
face=3D"Verdana">&nbsp;#CurrentPri# =
</font></small></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"13%"=20
align=3D"center" valign=3D"middle"><small></FONT>=20
<BR> =20
=20
<FONT size=3D2><font=20
=
face=3D"Verdana">&nbsp;#PreviousPri#</font></small></F=
ONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"36%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT =
size=3D2><small><font=20
=
face=3D"Verdana">&nbsp;#Nomenclature#</font></small></=
FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"15%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT =
size=3D2><small><font=20
face=3D"Verdana">&nbsp;#Niin#</font></small></FONT> =
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =
</tr></FONT>=20
<BR><FONT size=3D2></table></FONT> </P>
<P><FONT size=3D2><table border=3D"1" cellspacing=3D"0" =
width=3D"100%"=20
bordercolor=3D"000000"</FONT> =
<BR> =20
<FONT size=3D2>style=3D"border-top: medium none; border-bottom: medium =
none"></FONT> <BR><FONT size=3D2> =
=20
<tr></FONT> <BR><FONT size=3D2> =
=20
<td width=3D"17%" align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"000080"><strong><small>POINT OF</FONT> =
<BR><FONT=20
size=3D2>CONTACT</small></strong></font></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"17%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"000080"><strong><small>PART</FONT> <BR><FONT=20
size=3D2> =20
NUMBER</small></strong></font></td></FONT> =
<BR><FONT=20
size=3D2> <td width=3D"4%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
<FONT size=3D2><font=20
face=3D"Arial"</FONT> <BR><FONT=20
=
size=3D2>color=3D"000080"><strong><small>CAGE</small>=
;</strong></font></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"22%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"000080"><strong><small>PR/CONTRACT</FONT> =
<BR><FONT=20
size=3D2>NUMBER</small></strong></font></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =
</tr></FONT>=20
<BR><FONT size=3D2> =
<tr></FONT>=20
<BR><FONT size=3D2> =20
<td width=3D"17%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
<FONT =
size=3D2><small><font=20
face=3D"Verdana">&nbsp;#Poc#</font></small></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"17%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT =
size=3D2><small><font=20
=
face=3D"Verdana">&nbsp;#PartNo#</font></small></FONT> =
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"4%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT =
size=3D2><small><font=20
face=3D"Verdana">&nbsp;#Cage#</font></small></FONT> =
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"22%"=20
align=3D"center" valign=3D"middle"></FONT>=20
<BR> =20
=20
<FONT =
size=3D2><small><font=20
=
face=3D"Verdana">&nbsp;#PrContractNo#</font></small></=
FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR> <FONT =
size=3D2></tr></FONT>=20
<BR><FONT size=3D2></table></FONT> <BR><FONT size=3D2><cfset=20
Picture=3D"<img</FONT> <BR><FONT size=3D2>src=3D'<A=20
href=3D"http://140.229.102.109/cse/projects/#picwebaddress#'"=20
=
target=3D_blank>http://140.229.102.109/cse/projects/#picwebaddress#'</A> =
border=3D'0'>"></FONT> <BR><FONT size=3D2><table border=3D"1" =
cellpadding=3D"0" cellspacing=3D"0" width=3D"100%"</FONT> <BR><FONT=20
size=3D2>bgcolor=3D"FFFF00"</FONT> =
<BR> =20
<FONT size=3D2>bordercolor=3D"000000" style=3D"border-top: medium =
none;=20
border-bottom: medium</FONT> <BR><FONT size=3D2>none"></FONT> =
<BR><FONT=20
size=3D2> <tr></FONT> =
<BR><FONT=20
size=3D2> =20
<td width=3D"95%"=20
valign=3D"TOP"><font</FONT> <BR><FONT=20
size=3D2>face=3D"Verdana"><strong><small>PROGRAM</FONT> =
<BR><FONT=20
=
size=3D2>DESCRIPTION</small></strong></font></td>=
</FONT>=20
<BR><FONT size=3D2> <cfif =
detaillink is=20
not ""><td width=3D"5%" valign=3D"TOP"><a</FONT> <BR><FONT =
size=3D2>href=3D"<A=20
href=3D"http://140.229.102.109/cse/projects/#detaillink#index.html"=20
=
target=3D_blank>http://140.229.102.109/cse/projects/#detaillink#index.htm=
l</A>"><img</FONT>=20
<BR><FONT size=3D2>src=3D"more-details.gif" width=3D"100" =
height=3D"16"=20
border=3D"0"></a></td></cfif></FONT> <BR><FONT=20
size=3D2> </tr></FONT> =
<BR><FONT=20
size=3D2></table></FONT> </P>
<P><FONT size=3D2><table border=3D"1" cellpadding=3D"0" =
cellspacing=3D"0"=20
width=3D"100%"</FONT> <BR><FONT size=3D2>bordercolor=3D"000000"</FONT> =
<BR><FONT=20
size=3D2>style=3D"border-top: medium none; border-bottom: medium none" =
height=3D"206"></FONT> <BR><FONT size=3D2> <tr></FONT> =
<BR><FONT=20
size=3D2> <td width=3D"62%" valign=3D"top" =
align=3D"left"=20
height=3D"204"></FONT> =
<BR> =20
<FONT =
size=3D2><small><font=20
=
face=3D"Verdana">&nbsp;#Description#</font></small>&am=
p;nbsp;</FONT>=20
<BR> <FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> <td width=3D"40%" =
height=3D"204"=20
valign=3D"middle"></FONT> =
<BR> =20
<FONT size=3D2><cfif=20
#picwebaddress# is not ""></FONT>=20
<BR> =20
=20
<FONT =
size=3D2>#picture#</FONT>=20
<BR> =20
<FONT =
size=3D2><cfelse></FONT>=20
<BR> =20
=20
<FONT =
size=3D2>&nbsp;</FONT>=20
<BR> =20
<FONT =
size=3D2></cfif></FONT>=20
<BR> <FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> </tr></FONT> <BR><FONT=20
size=3D2></table></FONT> </P>
<P><FONT size=3D2><table border=3D"1" cellpadding=3D"0" =
cellspacing=3D"0"=20
width=3D"100%"</FONT> <BR><FONT size=3D2>bordercolor=3D"000000"</FONT> =
<BR> <FONT =
size=3D2>style=3D"border-top:=20
medium none; border-bottom: medium none"></FONT> <BR><FONT =
size=3D2> =20
<tr></FONT> <BR><FONT=20
size=3D2> <td width=3D"65%"=20
bgcolor=3D"FFFF00" valign=3D"top"></FONT>=20
<BR> =20
=20
<FONT=20
size=3D2><small><strong><font =
face=3D"Verdana"></FONT>=20
<BR> =20
=20
=20
<FONT =
size=3D2>DELIVERY</FONT>=20
<BR><FONT=20
=
size=3D2>SCHEDULE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>=20
<BR> =20
=20
=20
<FONT=20
=
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;&nbsp;&nbsp;</FONT>=20
<BR><FONT size=3D2> =20
=20
</font></strong></small></FONT>=20
<BR> =20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
size=3D"1" =
color=3D"408080"><b>RATE:</b></font></FONT>=20
<BR> =20
=20
<FONT size=3D2><font=20
face=3D"Verdana" size=3D"2" color=3D"Black"></FONT>=20
<BR> =20
=20
=20
<FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;#Rate#&nbsp; PER =
MONTH</FONT>=20
<BR> =20
=20
<FONT=20
size=3D2></font></small></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2></cfoutput></FONT> <BR><FONT =
size=3D2> =20
<td width=3D"34%" bgcolor=3D"#FFFF00" =
valign=3D"top"><p=20
align=3D"center"></FONT> =
<BR> =20
=20
<FONT size=3D2><font=20
face=3D"Verdana"><small><strong>DELIVERY</FONT> =
<BR><FONT=20
size=3D2>ALLOCATION</strong></small></font></FONT>=20
<BR> =20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =
</tr></FONT>=20
<BR><FONT size=3D2> =
<tr></FONT>=20
<BR><FONT size=3D2> <td =
width=3D"65%"=20
valign=3D"top"></FONT> =
<BR> =20
=20
<FONT size=3D2><table =
border=3D"1"=20
cellpadding=3D"0" cellspacing=3D"0"</FONT> <BR><FONT =
size=3D2> =20
=20
width=3D"100%" =
bgcolor=3D"#FFFFFF"=20
bordercolor=3D"#000000" style=3D"border:</FONT> <BR><FONT =
size=3D2>medium=20
none"></FONT> <BR><FONT size=3D2> =
=20
=20
<tr></FONT> <BR><FONT =
size=3D2> =20
=20
=20
<td width=3D"20%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"000080"><strong><small><small>BUY =
YEAR</FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT=20
=
size=3D2></small></small></strong></font></FONT> =
<BR> =20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
<td width=3D"20%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"000080"><strong><small><small></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT=20
size=3D2>QUANTITY</small></small></strong></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></font></FONT>=20
<BR> =20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
<td width=3D"30%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"000080"><strong><small><small></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT=20
size=3D2>EAD</small></small></strong></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></font></FONT>=20
<BR> =20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
<td width=3D"30%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
<FONT size=3D2><font =
face=3D"Arial"=20
color=3D"000080"><strong><small><small></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT=20
size=3D2>EDD</small></small></strong></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></font></FONT>=20
<BR> =20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
</tr></FONT> =
<BR><FONT=20
size=3D2> =20
=20
</table></FONT> =
<BR><FONT=20
size=3D2> =20
<table border=3D"1"=20
cellpadding=3D"0" cellspacing=3D"0" width=3D"100%"</FONT> <BR><FONT=20
size=3D2>bordercolor=3D"000000"</FONT> <BR><FONT =
size=3D2> =20
=20
style=3D"border: medium=20
none"></FONT> <BR> =20
=20
=20
<FONT size=3D2><cfoutput =
query=3D"qryGetSchedule"></FONT> <BR><FONT=20
size=3D2> =20
=20
=20
<tr></FONT> <BR><FONT =
size=3D2> =20
=20
=20
=20
<td width=3D"20%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
<FONT size=3D2><font=20
face=3D"Verdana" size=3D"2">&nbsp;#BuyYear#</font></FONT> =
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
=20
<td width=3D"20%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
<FONT size=3D2><font=20
face=3D"Verdana" size=3D"2">&nbsp;#Qty#</font></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
=20
<td width=3D"30%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
<FONT size=3D2><font=20
face=3D"Verdana"</FONT> <BR><FONT=20
=
size=3D2>size=3D"2">&nbsp;&nbsp;#Dateformat("#EAD#","mmm-yy")#=
</FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT =
size=3D2></font></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
=20
<td width=3D"30%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
<FONT size=3D2><font=20
face=3D"Verdana"</FONT> <BR><FONT=20
=
size=3D2>size=3D"2">&nbsp;#Dateformat("#EDD#","mmm-yy")#</font&=
gt;</FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
</tr></FONT>=20
<BR> =20
=20
=20
<FONT=20
size=3D2></cfoutput></FONT> <BR><FONT=20
size=3D2> =20
</table></FONT> =
<BR><FONT=20
size=3D2> </td></FONT> =
<BR><FONT=20
size=3D2> <td width=3D"34%"=20
valign=3D"top"></FONT> =
<BR> =20
=20
<FONT size=3D2><table =
border=3D"1"=20
cellpadding=3D"0" cellspacing=3D"0" width=3D"100%"</FONT> <BR><FONT=20
size=3D2>bordercolor=3D"#000000"</FONT>=20
<BR> =20
=20
=20
<FONT =
size=3D2>style=3D"border: medium=20
none"></FONT> <BR><FONT size=3D2> =
=20
=20
<tr></FONT> <BR><FONT =
size=3D2> =20
=20
=20
<td width=3D"63%" =
align=3D"center"=20
valign=3D"middle"><font face=3D"Arial"</FONT> <BR><FONT=20
size=3D2>color=3D"#000080"></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT=20
=
size=3D2><strong><small><small>SECA</small></s=
mall></strong></font></FONT>=20
<BR> =20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
<td width=3D"37%" =
align=3D"center"=20
valign=3D"middle"><font face=3D"Arial"</FONT> <BR><FONT=20
size=3D2>color=3D"#000080"></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT=20
=
size=3D2><strong><small><small>QUANTITY</small>&l=
t;/small></strong></font></FONT>=20
<BR> =20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
</tr></FONT>=20
<BR> =20
=20
=20
<FONT size=3D2><cfoutput =
query=3D"qryGetTotalSeca"></FONT>=20
<BR> =20
=20
=20
=20
<FONT size=3D2><cfset=20
Count=3DCount+#SumofQuantity#></FONT> <BR><FONT=20
size=3D2> =20
=20
=20
<tr></FONT> <BR><FONT =
size=3D2> =20
=20
=20
=20
<td width=3D"63%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
<FONT =
size=3D2><small><font=20
face=3D"Verdana">&nbsp;</FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT size=3D2><cfswitch =
expression=3D"#seca#"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfcase=20
value=3D"AIRLANT"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfset =
Symbol=3D"=20
(L)"></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT =
size=3D2></cfcase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfcase=20
value=3D"AIRPAC"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfset =
Symbol=3D"=20
(P)"></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT =
size=3D2></cfcase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfcase=20
value=3D"CNARF"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfset =
Symbol=3D"=20
(R)"></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT =
size=3D2></cfcase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfcase=20
value=3D"NAVAIR"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfset =
Symbol=3D"=20
(N)"></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT =
size=3D2></cfcase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfcase=20
value=3D"CNATRA"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfset =
Symbol=3D"=20
(T)"></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT =
size=3D2></cfcase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfcase=20
value=3D"NAMTRAGRU"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfset =
Symbol=3D"=20
(E)"></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT =
size=3D2></cfcase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfcase=20
value=3D"SYSCOM"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfset =
Symbol=3D"=20
(S)"></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT =
size=3D2></cfcase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT=20
size=3D2><cfdefaultCase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><cfset=20
Symbol=3D""></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT=20
size=3D2></cfdefaultcase></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT=20
size=3D2></cfswitch></FONT> =
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT size=3D2><a</FONT> =
<BR><FONT=20
=
size=3D2>href=3D"DeliveryDetail.cfm?niin=3D#niin#&seca=3D#seca#">#=
seca##Symbol#</a></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT=20
size=3D2></font></small></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
=20
<td width=3D"37%" =
align=3D"center"=20
valign=3D"middle"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
<FONT =
size=3D2><small><font=20
=
face=3D"Verdana">&nbsp;#NumberFormat("#SumOfQuantity#")#</FONT></P=
>
<P> =20
=20
=20
=20
=20
=20
<FONT=20
size=3D2></font></small></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
</tr></FONT>=20
<BR> =20
=20
=20
<FONT=20
size=3D2></cfoutput></FONT> =
<BR> =20
=20
=20
=20
<FONT =
size=3D2><tr></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
=20
<td width=3D"63%"=20
align=3D"center"><font face=3D"Arial"</FONT> <BR><FONT=20
size=3D2>color=3D"#000080"></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT=20
=
size=3D2><small><strong><small>TOTAL</small></=
strong></small></font></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
=20
<td width=3D"37%"=20
align=3D"center"></FONT> =
<BR> =20
=20
=20
=20
=20
=20
<FONT =
size=3D2><!---<cfif Count=20
gt 0>---></FONT> <BR> =20
=20
=20
=20
=20
=20
=20
<FONT=20
size=3D2><small><font</FONT> <BR><FONT=20
=
size=3D2>face=3D"Verdana">&nbsp;<cfoutput><b>#NumberFo=
rmat("#Count#")#</b></cfoutput></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
=20
<FONT=20
size=3D2></font></small></FONT>=20
<BR> =20
=20
=20
=20
=20
=20
<FONT=20
size=3D2><!---</cfif>---></FONT>=20
<BR> =20
=20
=20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
=20
</tr></FONT> =
<BR><FONT=20
size=3D2> =20
=20
</table></FONT> =
<BR><FONT=20
size=3D2> =20
</td></FONT> =
<BR><FONT=20
size=3D2> =20
</tr></FONT>=20
<BR> <FONT=20
size=3D2></table></FONT> =
<BR> =20
<FONT size=3D2><table border=3D"1" cellpadding=3D"0" =
cellspacing=3D"0"=20
width=3D"100%"</FONT> <BR><FONT size=3D2>bgcolor=3D"#FFFF00"</FONT>=20
<BR> =20
<FONT =
size=3D2>bordercolor=3D"#000000"=20
style=3D"border-top: medium none; border-bottom:</FONT> <BR><FONT =
size=3D2>medium=20
none"></FONT> <BR><FONT size=3D2> =
=20
<tr></FONT> <BR><FONT =
size=3D2> =20
<td=20
width=3D"100%"><strong><font</FONT> <BR><FONT=20
=
size=3D2>face=3D"Verdana"><small>NOTES</small></font>=
;</strong></td></FONT>=20
<BR><FONT size=3D2> =20
</tr></FONT>=20
<BR> <FONT=20
size=3D2></table></FONT> =
<BR> =20
<FONT size=3D2><table border=3D"1" cellpadding=3D"0" =
cellspacing=3D"0"=20
width=3D"100%"</FONT> <BR><FONT =
size=3D2>bordercolor=3D"#000000"</FONT>=20
<BR> =20
<FONT =
size=3D2>style=3D"border-top:=20
medium none"></FONT> <BR><FONT size=3D2> =
=20
<tr></FONT> <BR><FONT =
size=3D2> =20
<td width=3D"13%" =
align=3D"center"=20
valign=3D"middle"><font face=3D"Arial"</FONT> <BR><FONT=20
size=3D2>color=3D"#000080"></FONT>=20
<BR> =20
=20
=20
<FONT=20
=
size=3D2><strong><small><small>DATE</small></s=
mall></strong></font></FONT>=20
<BR> =20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
<td width=3D"87%" =
align=3D"center"=20
valign=3D"middle"><font face=3D"Arial"</FONT> <BR><FONT=20
size=3D2>color=3D"#000080"></FONT>=20
<BR> =20
=20
=20
<FONT=20
=
size=3D2><strong><small><small>DETAILS</small><=
;/small></strong></font></FONT>=20
<BR> =20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
</tr></FONT>=20
<BR> =20
<FONT size=3D2><cfoutput =
query=3D"qryGetNotes"></FONT> <BR><FONT size=3D2> =20
=
=20
<tr></FONT> <BR><FONT =
size=3D2> =20
=20
<td width=3D"13%" =
align=3D"CENTER"=20
valign=3D"TOP"><font face=3D"Verdana"></FONT>=20
<BR> =20
=20
=20
=20
<FONT=20
=
size=3D2><small>#Dateformat("#myDate#","mm/dd/yy")#</small>&l=
t;/font><br><br></FONT>=20
<BR> =20
=20
=20
<FONT =
size=3D2></td></FONT>=20
<BR><FONT size=3D2> =20
=20
<td width=3D"87%"=20
valign=3D"TOP"><font face=3D"Verdana"></FONT>=20
<BR> =20
=20
=20
=20
<FONT=20
=
size=3D2><small>#Details#</small></font><br><b=
r></FONT>=20
<BR><FONT size=3D2> =20
=20
</td></FONT> =
<BR><FONT=20
size=3D2> =20
=20
</tr></FONT>=20
<BR> =20
<FONT=20
size=3D2></cfoutput></FONT> =
<BR> =20
<FONT size=3D2></table></FONT> <BR><FONT =
size=3D2></body></FONT>=20
<BR><FONT size=3D2></html></FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From: Bud=20
[<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:webcreation@mindspring.=
com</A>]</FONT>=20
<BR><FONT size=3D2>Sent: Tuesday, September 05, 2000 10:56 AM</FONT> =
<BR><FONT=20
size=3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT =
size=3D2>Subject: Re: It=20
takes CF 1 minute to close DSN</FONT> </P><BR>
<P><FONT size=3D2>On 9/5/00, Miriam Hirschman penned:</FONT> <BR><FONT =
size=3D2>>I posted this question over the weekend, but I don't have =
a=20
solution so I</FONT> <BR><FONT size=3D2>am</FONT> <BR><FONT =
size=3D2>>posting=20
it again. I have a page that connects to one DSN1 and it has =
a</FONT>=20
<BR><FONT size=3D2>link</FONT> <BR><FONT size=3D2>>that calls a =
page which=20
connects to another DSN2. Now I get an error. CF</FONT> =
<BR><FONT=20
size=3D2>>is looking in DSN1 for a table that is in DSN2. If =
I wait a=20
minute then CF</FONT> <BR><FONT size=3D2>>seems to let go of DSN1 =
and I don't=20
get an error. I am using CF 4.0. Any</FONT> <BR><FONT=20
size=3D2>>help would be appreciated.</FONT> </P>
<P><FONT size=3D2>Hi Miriam. I'll ask again. We can't possibly guess =
without=20
seeing the</FONT> <BR><FONT size=3D2>code on the pages in question and =
maybe the=20
URL to the site.</FONT> <BR><FONT size=3D2>--</FONT> </P>
<P><FONT size=3D2>Bud Schneehagen - Tropical Web Creations</FONT> </P>
<P><FONT size=3D2>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/</FONT> =
<BR><FONT=20
size=3D2>ColdFusion Solutions / eCommerce Development</FONT> <BR><FONT =
size=3D2>[EMAIL PROTECTED]</FONT> <BR><FONT size=3D2><A=20
href=3D"http://www.twcreations.com/"=20
target=3D_blank>http://www.twcreations.com/</A></FONT> <BR><FONT=20
size=3D2>954.721.3452</FONT> <BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
------------</FONT>=20
<BR><FONT size=3D2>--</FONT> <BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit</FONT> <BR><FONT size=3D2><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or</FONT> <BR><FONT size=3D2>send a message to =
[EMAIL PROTECTED]=20
with 'unsubscribe' in</FONT> <BR><FONT size=3D2>the body.</FONT> </P>
<P><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0257_01C0174C.9993FDA0--
----------------------------------------------------------------------------
--
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.