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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
