Saturday, February 11, 2012
  Search
Support Forum
Download of report get 0x02 error
Last Post 27 Jan 2010 12:12 PM by Code 5. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
keithb
New Member
New Member
Send Private Message
Posts:8


--
25 Jan 2010 05:57 PM  
I have one form that I cannot download a report.  I can display it but when I click on any format to download I get this error:

'', hexadecimal value 0x02, is an invalid character.

Please Use your Browser Back button to Return

________

I'm in as Host and still have the problem.  This does not happen with any other form that I know of.  We also have had a lot of submission for this form.

Thanks.

keithb
New Member
New Member
Send Private Message
Posts:8


--
25 Jan 2010 06:05 PM  
I have also found out that when clicking through the pages that are displayed, there is one page that I get the error:
'', hexadecimal value 0x02, is an invalid character.

Is there a bad submission? If so, how do I get rid of it?

Thanks.
Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
25 Jan 2010 11:23 PM  
Yes somehow an invalid char got into your data.
You can try the SQL below to see if you can find the record

Select FormDataID from C5SLLC_FormData Where FormData like '%' + CHAR(2) + '%'

I tested this on SQL 2008 not sure if it will work on an earlier version

After you find the record maybe we can try a replace statement
keithb
New Member
New Member
Send Private Message
Posts:8


--
26 Jan 2010 02:20 PM  
I run SQL 2005 and when I run that command I get:

(0 row(s) affected)

Anything else I can try?  Thanks.
Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
27 Jan 2010 12:12 PM  
The only thing I can suggest it to try to narrow down the date range to find the offending record then delete it.
You are not authorized to post a reply.

Active Forums 4.2
Copyright 2004-2012 Code 5 Systems, LLC.