Thanks Ksuh. This helped by displaying more log info than before. One problem persists
though, somewhere after displaying a good number of records, it craps out and displays
html code right to the end.
Any help would be appreciated.
Robert O.
HWW
Here's my code:
<cfquery name="getsomedata" datasource="application_log">
select * from application2
order by number desc
</cfquery>
<p><font face="Arial"><b>CF Error Log for WWW.HWWILSON.COM</b>
</font>
<cfoutput query="getsomedata">
<b>Date: </b>#replace(col002, """", "", "all")#<b><br>
Time:</b></font> #replace(col003, """", "", "all")#<b><font face="Arial" size="2"><br>
IP:</font></b> <font face="Arial" size="2">#replace(col004, """", "",
"all")#</font><b><font face="Arial" size="2"><br>
Browser:</font></b> <font face="Arial" size="2">#replace(col005, """", "",
"all")#</font><b><font face="Arial" size="2"><br>
<!--- Error:</font></b> <font face="Arial" size="2">#replace(replace(col006, "<xmp>",
"", "all"), ">", "", "all")#</font> --->
<br>
Error:</font></b> <font face="Arial" size="2">#htmlEditFormat(col006, "-1")#</font>
<hr>
<!--- </cfloop> --->
</cfoutput>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 12:20 PM
To: CF-Talk
Subject: Re: truncated log data
Use htmlEditFormat... use htmlEditFormat.... Garrkkk...
My last word on this planet will be "htmlEditFormat"
----- Original Message -----
From: Robert Orlini <[EMAIL PROTECTED]>
Date: Tuesday, April 1, 2003 9:54 am
Subject: truncated log data
> I'm using SQL via CF to try to read my CF application.log file and
> display the data on screen. I stripped out some characters on some
> of the rows, unfortunately on some rows all the data does not display.
>
> For example, one row has this info:
>
> "Error","TID=227","04/01/03","10:57:28","1XX.XX.XX.XX","Mozilla/4.0 (compatible;
> MSIE 6.0; Windows NT 5.0)","<P>An error occurred while evaluating the expression:
> <P><PRE>#FORM.lcatalog# </PRE></P></P>Error near line 31, column 3.<HR><P>Error
> resolving parameter <B>FORM.LCATALOG</B><P><P>The specified form field cannot be
> found. This problem is very likely due to the fact that you have misspelled the form
> field name.<P><P> <p>The error occurred while processing an element with a general
> identifier of (#FORM.lcatalog#), occupying document position (31:2) to (31:16) in
> the template file
> d:\Inetpub\wwwroot\wwebforms\catalog\HWcatalog.cfm.</p><P><P>Date/Time: 04/01/03
> 10:57:28<BR>Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)<BR>Remote
> Address: 1XX.XX.XX.XX<BR>HTTP Referer: http:
>
> I'm using this code to display it and strip some fields:
>
> Error: replace(replace(col006, "<p>", "", "all"), ">", "", "all")#
>
> It only displays: "An error occurred while evaluating the
> expression:" and no more of the line.
>
> Anything I'm missing here? Thanks.
>
> Robert Orlini
> HW Wilson
> 718-588-8400 x2656
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
