I am sure you must be creating a dynamic SQL statement from all the options
entered in the form and then using Statement object to insert a record.
Use PreparedStatment object instead. This should solve your problem.
Do let me know if you want any more help.
Kishore Raghavan
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Kotireddy Mutyam
Sent: Monday, June 05, 2000 12:57 AM
To: [EMAIL PROTECTED]
Subject: how to insert a filed consisting of single quote in msaccess?
hi friends,
I am working on JSP using JRun with MSAccess as a Database.
I am not able to insert a field for example if i enter the value in text
field like "b'day" it is throwing exception. How to overcome the
error?
TIA
kotireddy
[EMAIL PROTECTED]
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
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".
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
