Solved

How do control characters get entered in textbox

Posted on 2004-08-20
6
426 Views
Last Modified: 2008-03-03
I support an online credit card payment system.  Every once in a while the data the customer enters into a textbox (different ones) has control characters at the end of the text data.  Specifically newline carriage return (Hex 0D0A or Hex 0D0A0D0A).  I have not been able to input these characters using IE 6.0 on XP Pro or using IE 6.0 on Win 2000 server.  Since I can't input them I can't test to see if I have successfully stripped them before using the data.

Does anyone know how the customer is entering these control characters?  Thanks.  

BettyB.
0
Comment
Question by:bettyb1656
6 Comments
 
LVL 8

Accepted Solution

by:
trevorhartman earned 125 total points
ID: 11856195
you can sometimes copy the value of a control character from another program, like notepad.  when you paste them into a field, they show up as a little box
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 11856425
Building on what trevorhartman  said, the most likely cause is pasting from Word or Excel.

Fritz the Blank
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 11857270
>>Does anyone know how the customer is entering these control characters?<<
Sure:
Hex 0D0A = Alt+13 Alt+10.  As in &#9834;&#9689;
Hex 0D0A0D0A = Alt+13 Alt+10 Alt+13 Alt+10, as in &#9834;&#9689;&#9834;&#9689;
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:bettyb1656
ID: 11857359
I couldn't get anything from notepad, word, or excel to enter the control characters that are giving me trouble.

Alt+13 Alt+10 show on the input screen and in the database and do not cause the same problems.

Also, my users are quite unsophisticated and I doubt they ever use the alt key.  One user entered his address with hex 0D0A at the end three times in a row. I believe that the problem is using a MAC or a Unix variant, but I don't know and don't have either to test with.

Another problem that I have run into is that production is SQL Server 7 which shows the hex characters as a square box but my test systems are SQL Server 2000 and the hex characters show as spaces.  Is there any configuration to set to have the SQL Server 2000 show the square boxes?
0
 
LVL 8

Expert Comment

by:trevorhartman
ID: 11857733
not sure on display, but is it possible that the control character could be added to the value elsewhere in your script?
0
 

Author Comment

by:bettyb1656
ID: 11857839
I don't think it is possible.  The system has been running since 2001 and there have only been 6 times that newline carriage return characters have appeared in the database.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ASP Focus problem 3 67
ASP/VB email question 4 46
Jquery Check against database on select from auto fill not working in all browsers 5 41
Html CheckBox obtain Its Value 5 27
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question