Hi
try to insert two single quotes ex : ' bla bla bla '' bla bla bla '
in the SQL statement will give you in the database 'bla bla bla ' bla
bla bla '
Thierry
shashi kanth goud
<sayshashi@rediffmail To: [EMAIL PROTECTED]
.com> cc:
Sent by: "A mailing Subject: Re: inserting single
quote in sql server
list for discussion
about Sun
Microsystem's Java
Servlet API
Technology."
<SERVLET-INTEREST@JAV
A.SUN.COM>
30/10/2001 14:29
Please respond to
shashi kanth goud
hai all,
Iam using sql server.While i want to insert single quote in
database i get follwing error
java.sql.SQLException: [Atinav][JDBC SQL Server Driver] Missing single
quotes.
thanx in advance
Shashi
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
