Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > problem characters

Thread Tools

problem characters

John Hopper
Posts: n/a
Dim txtComments As String = Request.Form("tbComments")
causes an "unterminated string error" at runtime
when "tbComments" contains an apostrophe, a carriage
return, etc. and they are being rendered in the browser
within the txtComments textbox.

Before .net I replaced "'" with "''", etc and all was
well. This doesn't seem to work now. SqlServer stores a
carriage return but truncates the text in "open table,
return all rows" at the point of occurance. I've tried
htmlEncode, chr(13), etc etc

I've replaced the "'" with "", since nothing else seemed
to work.

How are others solving this type of problem?

Thank you,

John Hopper
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
pointers to constant characters and constant pointers to characters C Programming 4 12-14-2006 11:10 PM
How to convert HTML special characters to the real characters with a Java script Stefan Mueller HTML 3 07-23-2006 10:09 PM
Reversible replacement of whitespace characters with visible characters Micah Python 2 06-02-2006 09:55 PM
Convert Raw Text Escaped Characters to Characters Java 2 07-11-2005 09:17 PM
help-> xslt transformation to pdf (chinese characters changed to # characters) omegaman XML 1 09-21-2004 10:44 PM