avoid which characters in text fields with vb- and jscript?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Working on a project making an intranet application - using mysql in a
native win2k3 srv/xp clients environment on our IIS 6.0 intranet
server. Have made various tables storing user input, and want to make
sure to clean user inputs for unwanted characters before storing in
dbase. Using the vbscript Replace funktion Im able to remove quotes
(single and double), and until recently thought this was sufficient,
however just found out that a line break - (user hitting enter in a
text field) will result in errors when retrieving the text from dbase.
Can anybody point me to a good ressource for a complete list of which
characters (hidden and printed) is likely to result in errors when
handled in vbscript (serverside) and jscript (clientside) - would also
be nice with a regular expression example of how to remove a list of
characters from a string (jscript and vbscript)

regards
Jakob Outzen
jo@xxxxxxxxxxxxxxxxx (remove "cutitout" to reply)
.



Relevant Pages

  • Ignore F1-F12 keys when user enters text input on console
    ... The user input it taken using STDIN.getc. ... the entered characters are not displayed and each character is ... obscured by displaying an asterix. ... def TestFunc ...
    (comp.lang.ruby)
  • Re: [Full-Disclosure] How T-Mobils network was compromised
    ... User input is passed to a function which sanitizes the input by ... converting "dangerous" characters to HTML representations. ... Function is flawless from a programming perspective and performs as ... should have occurred is a check for "../" in a loop. ...
    (Full-Disclosure)
  • Re: What chars are considered safe?
    ... > I was just writing a sanitisation route for a bit of user input. ... > an English text description of a product, and will go into a DB, then back ... > characters that I considered safe and stripping out everything else. ...
    (comp.lang.php)
  • how to get rid of trailing blank space in JTextField
    ... My problem is not how to restrict user input to JTextField to a fixed ... length as the column of characters I entered. ... and I can see that the textField does shrink a little bit compare to ...
    (comp.lang.java.gui)
  • Re: Non-ascii email subject and header encoding
    ... I need to mailemails with user input that does contain non-ascii ... but I cannot find a PHP function to encode the input string in this ... send messages and supports headers with non-ASCII characters encoded as ...
    (comp.lang.php)