ribbegrd
asked on
' interrupts string input
In a web application (uses ASP), users are asked to answer a question through a multiple-line input box. When using the ' char, as in "I'm", the input following to that gets ignored when storing the data in the database. I know the cause - but how can I prevent it from occuring?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
depends on how you construct the statement. Maybe email me some
sample code and I can send you back a version that does is.
My Email is us@datapec.datagroup.de
sample code and I can send you back a version that does is.
My Email is us@datapec.datagroup.de
using the Replace function replace the ' with 2x '
REPLACE(Request.Form("fiel d_whatever "), "'", "''")
But you can also URLEncode the string and URLDecode it back when you get the data from the database.
REPLACE(Request.Form("fiel
But you can also URLEncode the string and URLDecode it back when you get the data from the database.
ASKER