Solved

How do control characters get entered in textbox

Posted on 2004-08-20
6
427 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
If-Then-Else ASP problem 6 72
One field not displaying content (ASP Classic) 8 35
window close link 7 35
ASP Classic Query that needs to display more information 18 35
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

726 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