Use CFSaveContent to capture the CFDump in a variable. Then, use #htmlEditFormat()# to escape all of the content when storing it in the DB.
Oh, I strongly, STRONGLY, suggest looking at CFQueryParam. M!ke -----Original Message----- From: Charles Sheehan-Miles [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 8:16 PM To: CF-Talk Subject: Exception reporting Hello all, Up until recently, I¹ve been using a setup to email me any exception reports, with cfdumps of all of the interesting scopes. It¹s helpful, but as I rework my app I¹ve building in a bug tracking function. Right now, when the onError method in application.cfc is called, it: 1. checks to see if the same page has generated an error and has an open ticket 2. if not, creates a new ticket 3. if a ticket exists, it appends the current error to the ticket. What I¹d like to do is take all the good stuff cfdump provides and include it in the bug report. That way I can pull up all the open exceptions and read the error at my leisure, and NOT email it out. I can¹t seem to figure out a way to do this. I tried something like this: <cfquery datasource=²#db#²> Insert into tblTroubleTickets (orgid, description, blah blah,,.....) values (#orgid#, <cfdump var=²#exception#²>¹, blah blah....) </cfquery> Unfortunately, it seems that putting the cfdump inside the sql query creates some horrible problems, and the record never gets created. Has anyone tried this? Is there a way to easily do it that I¹m just missing? Thanks, Charles ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
