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
