Hi,
You have to use sql escape character when you insert
,
'
etc.
Here we go...
Add a ' (single quote) before any special character.
Eg:
You are a '' culprit
results into
You are a ' culprit
Regards
Yesuda
---------- Original Message ----------------------------------
From: Venkata Ratnam Vadlamannati <[EMAIL PROTECTED]>
Reply-To: A mailing list about Java Server Pages specification and
Date: Sat, 6 Jan 2001 19:49:50 -0800
>Hi all
>
>Can anybody suggest me how to insert into a text
>column with text such as "abc's question", "he said "I
>am not a culprit", it's your fault" etc.,
>
>I'm using jdbc-odbc drivers for sql7.0. and HTML forms
>with JSP to process backend.
>
>As the string is with characters such as ", ', normal
>insert statement fails
>
>please suggest me a workaround to do the above
>
>thanks in advance
>
>Venkat
>
>PS:Plese email your suggestions directly to
>[EMAIL PROTECTED]
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Photos - Share your holiday photos online!
>http://photos.yahoo.com/
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
