We're recently enabled the feature to have all coldfusion error captured and
an error page displayed. In this page we send ourselves an email with error
info. The weird thing is that some of the messages go through and some of
them dont, our cf server says: MAIL\spool\4D.cfmail. SMTP server replied
"Invalid data in message" Moved file to d:\CFUSION\MAIL\undelivr\E9.cfmail
The email is in html format and we loop through the error struct and builds
a table with all the info, I'd appreciate any help on this.
Our email looks like this (copy/paste it to an html file should make it more
readable):
x-cf-version: 4.5.0
x-cf-server: 195.41.53.44
x-cf-port: 25
x-cf-timeout: 600
x-cf-from: [EMAIL PROTECTED]
x-cf-to: [EMAIL PROTECTED]
Content-type: text/html Date: Mon, 05 Mar 2001 17:00:51 +0100 From:
[EMAIL PROTECTED] Subject: error To: [EMAIL PROTECTED] An
error occured, the following information was gathered:<br><br> <table
cellpadding="2" cellspacing="0" border="1" bordercolor="#000000">
<tr> <td>BROWSER</td>
<td>WebTrends/3.0 (WinNT) </td> </tr>
<tr> <td>DATETIME</td> <td>03/05/01
17:00:51 </td> </tr> <tr>
<td>DETAIL</td> <td>[Microsoft][ODBC Driver Manager]
Data source 'MAERSK_INTERF' not found and no default driver
specified<P><B>Hint</B>: In order to use ODBC data sources
with Cold Fusion you must create the data source using the Data Sources page
of the Cold Fusion Administrator. In addition, if you are running under
Windows NT you must make sure that the Data Source is created as a System
DSN in order for it to be available to
ColdFusion.<P><P> </td> </tr>
<tr> <td>DIAGNOSTICS</td> <td>ODBC
Error Code = IM002 (Data source not found and no default driver
specified)<P> [Microsoft][ODBC Driver Manager] Data source
'MAERSK_INTERF' not found and no default driver
specified<P><B>Hint</B>: In order to use ODBC data sources
with Cold Fusion you must create the data source using the Data Sources page
of the Cold Fusion Administrator. In addition, if you are running under
Windows NT you must make sure that the Data Source is created as a System
DSN in order for it to be available to
ColdFusion.<P><P><p>The error occurred while processing an
element with a general identifier of (CFQUERY), occupying document position
(7:1) to (7:68).</p> </td> </tr>
<tr> <td>ERRORCODE</td>
<td>IM002 </td> </tr> <tr>
<td>EXTENDEDINFO</td> <td> </td>
</tr> <tr>
<td>GENERATEDCONTENT</td> <td>
<html>
<head>
<title>Trafikinformation</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
<link rel="stylesheet" href="../../css/cargo.css">
<META HTTP-EQUIV="PRAGMA"
CONTENT="NO-CACHE"><META HTTP-EQUIV="Expires"
CONTENT="-1"></head>
<body bgcolor="#FFFFFF">
<!-- ****************************** START MENUER
***************************** //-->
<script language="JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features,width,height) { //v2.0
window.open(theURL,winName,features + "width=" + width +
",height=" + height + ",left=" + ((screen.width - width)
/ 2) + ",top=" + ((screen.height - height) / 2));
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr;
for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++)
x.src=x.oSrc;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array;
for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc)
x.oSrc=x.src; x.src=a[i+2];}
}
function MM_findObj(n, d) { //v3.0
var p,i,x; if(!d) d=document;
if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for
(i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++)
x=MM_findObj(n,d.layers[i].document); return x;
}
function ud ()
{
parent.parent.parent.menu.t_ud();
}
function over()
{
parent.parent.parent.menu.t_over();
}
function luk(id)
{
parent.parent.parent.menu.t_luk(id);
}
//-->
</script>
<div id="Layer1" style="position:absolute; left:126px;
top:8px; width:95px; height:114px; z-index:1; visibility:
hidden"><a
href="/cfml/frameset/7fsl3.cfm?MenuName=allDestination&ContentPage=
/cfml/rutefly/destination/defaultside.cfm"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image16','','/picsDK/kn1_3-1.gif',1);over()&
quot; target="indhold2"><img name="Image16"
border="0" src="/picsDK/kn1_3.gif"></a><a
href="#" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image21','','/picsDK/kn1_8-1.gif',1);over()&
quot;
onClick="MM_openBrWindow('http://www.oag.com/tt/airlines/dm/index.htm',
'TaxFree','scrollbars=yes,resizable=yes,status=0,','700','500')"><
;img name="Image21" border="0"
src="/picsDK/kn1_8.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Price&ContentPage=/cfml/rut
efly/priser/listCampaignPrices.cfm"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image14','','/picsDK/kn1_1-1.gif',1);over()&
quot; target="indhold2"><img name="Image14"
border="0" src="/picsDK/kn1_1.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Price&ContentPage=/cfml/Int
ernetBooking/internetBooking.cfm"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image20','','/picsDK/kn1_7-1.gif',1);over()&
quot; target="indhold2"><img name="Image20"
border="0" src="/picsDK/kn1_7.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Price&ContentPage=/cfml/rut
efly/forretningspartnere/niv_3-12-1.cfm"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image17','','/picsDK/kn1_4-1.gif',1);over()&
quot; target="indhold2"><img name="Image17"
border="0" src="/picsDK/kn1_4.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Price&ContentPage=/cfml/fra
meset/7blank.cfm&MenuNos=164&firstload=yes"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image18','','/picsDK/kn1_5-1.gif',1);over()&
quot; target="indhold2"><img name="Image18"
border="0" src="/picsDK/kn1_5.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Travelinfo&ContentPage=/cfm
l/frameset/7blank.cfm&MenuNos=195&firstload=yes"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image15','','/picsDK/kn1_2-1.gif',1);over()&
quot; target="indhold2"><img name="Image15"
border="0" src="/picsDK/kn1_2.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=nomenu&ContentPage=/cfml/sl
ips/slips.cfm" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image19','','/picsDK/kn1_6-1.gif',1);over()&
quot; target="indhold2"><img name="Image19"
border="0" src="/picsDK/kn1_6.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=nomenu&ContentPage=/cfml/ch
arter/shopping.cfm" target="indhold2"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image22','','/picsDK/kn1_9-1.gif',1);over()&
quot; onMouseOut="MM_swapImgRestore();t_ud()"><img
name="Image22" border="0"
src="/picsDK/kn1_9.gif"></a>
</div>
<div id="Layer2" style="position:absolute; left:187px;
top:8px; width:108px; height:32px; z-index:1; visibility:
hidden"><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Charter&ContentPage=/cfml/c
harter/niv_4-2.cfm" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image1411','','/picsDK/kn2_1-1.gif',1);over(
)" target="indhold2"><img name="Image1411"
border="0" src="/picsDK/kn2_1.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Charter&ContentPage=/cfml/t
rafikprogram/niv_8.cfm" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image1511','','/picsDK/kn2_2-1.gif',1);over(
)" target="indhold2"><img name="Image1511"
border="0" src="/picsDK/kn2_2.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Travelinfo&ContentPage=/cfm
l/frameset/7blank.cfm&MenuNos=195&firstload=yes"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image1611','','/picsDK/kn2_3-1.gif',1);over(
)" target="indhold2"><img name="Image1611"
border="0" src="/picsDK/kn2_3.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Charter&ContentPage=/cfml/k
atalog/index.cfm" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image1711','','/picsDK/kn2_4-1.gif',1);over(
)" target="indhold2"><img name="Image1711"
border="0" src="/picsDK/kn2_4.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=TravelInfo&ContentPage=/cfm
l/frameset/7blank.cfm&MenuNos=434&firstload=yes"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image1811','','/picsDK/kn2_5-1.gif',1);over(
)" target="indhold2"><img name="Image1811"
border="0" src="/picsDK/kn2_5.gif"></a><a
href="#"
onClick="MM_openBrWindow('http://www.taxfree.gategourmet.dk','TaxFree',
'scrollbars=yes,resizable=yes,status=0,','760','500')"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image1911','','/picsDK/kn2_6-1.gif',1);over(
)" ><img name="Image1911" border="0"
src="/picsDK/kn2_6.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=AdHocFlights&ContentPage=/c
fml/charter/niv_4-1-1.cfm"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image2011','','/picsDK/kn2_7-1.gif',1);over(
)" target="indhold2"><img name="Image2011"
border="0"
src="/picsDK/kn2_7.gif"></a></div>
<div id="Layer3" style="position:absolute; left:448px;
top:8px; width:95px; height:74px; z-index:1; visibility:
hidden"><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Company&ContentPage=/cfml/m
aerskair/niv_2-5-1.cfm&MenuNos=69&firstload=yes"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image142','','/picsDK/kn6_1-1.gif',1);over()
" target="indhold2"><img name="Image142"
border="0" src="/picsDK/kn6_1.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Company&ContentPage=/cfml/m
aerskair/niv_2-4.cfm" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image181','','/picsDK/kn6_5-1.gif',1);over()
" target="indhold2"><img name="Image181"
border="0" src="/picsDK/kn6_5.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Company&ContentPage=/cfml/m
aerskair/niv_2-3.cfm" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image171','','/picsDK/kn6_4-1.gif',1);over()
" target="indhold2"><img name="Image171"
border="0" src="/picsDK/kn6_4.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Company&ContentPage=/cfml/m
aerskair/niv_2-2.cfm" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image161','','/picsDK/kn6_3-1.gif',1);over()
" target="indhold2"><img name="Image161"
border="0" src="/picsDK/kn6_3.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=Company&ContentPage=/cfml/m
aerskair/niv_2-1.cfm" onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image152','','/picsDK/kn6_2-1.gif',1);over()
" target="indhold2"><img name="Image152"
border="0"
src="/picsDK/kn6_2.gif"></a></div>
<div id="Layer4" style="position:absolute; left:380px;
top:95px; width:95px; height:74px; z-index:1; visibility:
hidden"><a
href="/cfml/frameset/7fsl3.cfm?MenuName=cargo&ContentPage=../cargo/
niv_5-2.cfm" target="indhold2"
onMouseOut="MM_swapImgRestore();ud()"
onMouseOver="MM_swapImage('Image242','','/picsDK/kn9_1-1.gif',1);over()
;"><img name="Image242" border="0"
src="/picsDK/kn9_1.gif"></a><a
href="/cfml/frameset/7fsl3.cfm?MenuName=GenSalesAgent&menunos=211&a
mp;ContentPage=../cargo/niv_5-1.cfm"
onMouseOut="MM_swapImgRestore();ud()"
target="indhold2"
onMouseOver="MM_swapImage('Image243','','/picsDK/kn9_2-1.gif',1);over()
;"><img name="Image243" border="0"
src="/picsDK/kn9_2.gif"></a>
</div>
<!-- ****************************** SLUT MENUER
****************************** //-->
<table width="550" border="0"
cellspacing="0" cellpadding="0"
align="center">
<tr>
<td colspan="3"><img
src="../../picsall/pixel.gif" width="1"
height="18"></td>
</tr>
<tr>
<td colspan="3" align="left"
valign="top" class="overskrift">Ankomster</td>
</tr>
<tr>
<td colspan="3" align="left"
valign="top" class="overskrift">&nbsp;</td>
</tr>
<tr>
<td colspan="3" align="left"
valign="top">
<table width="100%" border="0"
cellspacing="0" cellpadding="1">
<tr>
<td class="underoverskrift" width="15%"
bgcolor="#003366">
<div align="center"><font
color="#FFFFFF">Dato</font></div>
</td>
<td class="underoverskrift" width="15%"
bgcolor="#003366">
<div align="center"><font
color="#FFFFFF">Afgang</font></div>
</td>
<td class="underoverskrift" width="15%"
bgcolor="#003366">
<div align="center"><font
color="#FFFFFF">Ankomst</font></div>
</td>
<td class="underoverskrift" width="15%"
bgcolor="#003366">
<div align="center"><font
color="#FFFFFF">Rute</font></div>
</td>
<td class="underoverskrift" width="20%"
bgcolor="#003366">
<div align="center"><font
color="#FFFFFF">Fra</font></div>
</td>
<td class="underoverskrift" width="20%"
bgcolor="#003366">
<div align="center"><font
color="#FFFFFF">Til</font></div>
</td>
</tr>
</tr>
</td> </tr> <tr>
<td>HANDLER_TYPE</td> <td>ERROR </td>
</tr> <tr> <td>HTTPREFERER</td>
<td> </td> </tr> <tr>
<td>MAILTO</td>
<td>[EMAIL PROTECTED] </td> </tr>
<tr> <td>MESSAGE</td> <td>ODBC
Error Code = IM002 (Data source not found and no default driver
specified)<P> </td> </tr> <tr>
<td>NATIVEERRORCODE</td> <td>0 </td>
</tr> <tr> <td>QUERYSTRING</td>
<td> </td> </tr> <tr>
<td>REMOTEADDRESS</td> <td>192.168.250.9 </td>
</tr> <tr> <td>SQLSTATE</td>
<td>IM002 </td> </tr> <tr>
<td>TEMPLATE</td>
<td>\\WEBFILES\DATA\MAERSKAIR2000\CFML\TRAFIKPROGRAM\TRAFIKINFORMATION.CFM&n
bsp;</td> </tr> <tr>
<td>TYPE</td> <td>DATABASE </td>
</tr> <tr> <td>HTTP HOST</td>
<td>http://www.maerskair.dk</td> </tr> <tr>
<td>PATH</td>
<td>/cfml/trafikprogram/trafikinformation.cfm</td> </tr>
<tr> <td>SERVER NAME</td>
<td>www.maerskair.dk</td> </tr> </table>
Regards Bjorn Jensen
TravelMarket Interactive - www.travelmarket-interactive.com
Phone: +45 76433032
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
