hi,
sorry for not being clear.. here it is in details.
suppose the data comes "guru's" which has a single quote.
then replace guru's with guru''s which has now two single quotes.
when you execute the query then oracle will ignore one of the single
quotes.
This problem was also once mine. this is only specific to oracle
only.
about other database i do not know.
please let me know the details after the change.
With regards
guru
----------------------------------------------------
Gurumoorthy Raghupathy
Cisco Projects
Zensar Technologies
Pune India
Hello : 6684001/2/3 Ext : 626/616
Email : [EMAIL PROTECTED]
Email : [EMAIL PROTECTED]
--------------------------------------------------
-----Original Message-----
From: sharma Sumeet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 9:20 AM
To: [EMAIL PROTECTED]
Subject: Re: Servlet Bug!!
hi guru
i have used single quotes with oracle which is part of data
regards sumeet
> -----Original Message-----
> From: R.Gurumoorthy [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 13, 2001 2:28 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Servlet Bug!!
>
> if you are using oracle as backend then replace
> every single quote with two single quote which is part of data.
>
> with regards
> guru
>
>
> ----------------------------------------------------
> Gurumoorthy Raghupathy
> Cisco Projects
> Zensar Technologies
> Pune India
> Hello : 6684001/2/3 Ext : 626/616
> Email : [EMAIL PROTECTED]
> Email : [EMAIL PROTECTED]
> --------------------------------------------------
>
>
> -----Original Message-----
> From: Jennifer Feeney [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 09, 2001 7:27 AM
> To: [EMAIL PROTECTED]
> Subject: Servlet Bug!!
>
>
> Hi all,
>
> Once again, thanks to anyone that can offer any help or advise on
> this one!
>
> I have found a bug in my servlet......
>
> Description:
> ========================================================
> I have a servlet developed that allows users to register for
> a service, it all works great, except for one thing, if a person
> enters a Surname of the O'Rourke, O'Reilly, type I get the following
> message........
>
> java.sql>SQLException:Syntax Error(Missing Operator) in expression
> Query.
>
> I know what causes the error, its the " ' " character that messes
> up my InsertIntoDB query......
>
> The code snippet below is what I am using, can anyone tell me how i
> could modify it to allow surnames of this type to be accepted and not
> generate an error.
>
> Code Snippet:
> ================================================================
>
> boolean success = insertIntoDB(
> "'" + email + "','" + firstName + "','" + lastName + "','" +
> telNo + "','" + address1 + "','" + address2 +
> "','" + county + "','" + country + "','" +
> (String.valueOf(IdNo)) + "','" + password + "'");
> ================================================================
> End Code:
>
> Ps I tried the archives, but the server is down.....
>
> Thanks again to anyone that may be able to help.
>
> Regards,
> Jennifer
>
> _____________________________________
>
> Get your free E-mail at http://www.ireland.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
___________________________________________________________________________
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
