hi poornima,
' (apostrophe) is a keyword in SQL server.
append it with another " ' " while preparing the sql string.
-Naveen
----- Original Message -----
From: poornima visvesvaran <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 10:25 AM
Subject: error posting data which is having aphostrophy symbol
> Hi friends,
>
> I am using sql server as my backend. Servlets are my
> front end. When i try to post html data which is
> having aphostrophy (') symbol,it's giving error.
> Please help me how to remove this error. I am
> receiving data's with this symbol only.
>
> Thanks in advance.
>
> Poornima Visvesvaran.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great prices.
> http://auctions.yahoo.com/
>
> ___________________________________________________________________________
> 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
