; )
I was asking my boss the same question ...
"T.A. Flores" wrote:
> I don't necessarily think the discussion was heated in any manner,
> however, with that said . . .
>
> This has been taken off line - since it has become, for some,
> uninteresting and, in all actuality, only vaguely related to Servlets.
>
> My question would be why are you using access when other alternatives
> are available? I know nothing of access or JDBC/ODBC bridges since I
> don't need or use them.
>
> ----- Original Message -----
> From: Yeo Lee Seng <[EMAIL PROTECTED]>
> Date: Friday, April 6, 2001 5:51 am
> Subject: Re: Escape apostrophe
>
> > Hi,
> >
> > I had been following the "heated" discussion about the apostrophe
> > thingyCould Flores kindly elaborate on his example on the
> > StringBuffer ?
> > I had tried both the prepareStatement & StringBuffer approach
> > The prepareStatement worked !
> > but the StringBuffer din ... (my setup : MS Access + jdbc.odbc .. ;p)
> > Does this particular behaviour very much depend on the driver ?
> >
> > "T.A. Flores" wrote:
> >
> > > FYI - keep posts below 300 lines or they will be rejected. Now
> > back to
> > > our regularly sponsored programming. . . .
> > >
> > > Stephen we'd all like to be right . . .
> > >
> > > Hmmm - not quite sure and at this point I won't be able to find out
> > > because I am no longer with the company where I had this
> > problem. Not
> > > sure which version of Oracle 8i we were using <shrug> and I almost
> > > always use the thin driver. But this I do know everyone had that
> > > particular issue.
> > >
> > > The problem as I see it would be determing what the exact cause
> > would> be like chasing a needle in a haystack. Can't say it was my IDE
> > > because I don't use one, was it the JSP to servlet to the
> > whatever and
> > > something being lost? A database issue? The only character I
> > have ever
> > > had an issue with is that <edit> single quote and as far as the
> > > prepared statement I find that I am usually using it.
> > >
> > > Are you using a Connection pool? What app server are you using? The
> > > problem your having with the prepared statement doesn't sound
> > > right . . . have you tried something like ?
> > >
> > > try{
> > > ps.close( );//close the statment
> > > conn.closeConnection( );//close
> > connection> }catch . . .. {
> > >
> > > When I get more time I'll take another look at the single quote
> > thing,> but for now - my lesson for the day - keep an open mind :-)
> > >
> > > ----- Original Message -----
> > > From: Stephen Casey <[EMAIL PROTECTED]>
> > > Date: Thursday, April 5, 2001 9:30 am
> > > Subject: Re: how to escape apostrophe
> > >
> > > > Dion's example below is pretty much the same as what I use. I'm
> > > > not sure
> > > > what the database or JDBC driver is. I'm going against an
> > Oracle 8.1.6
> > > > database using their thin driver. So far I've been able to insert
> > > > anythinga user types into the html form (i.e. ', ; , : , & ,
> > > > %). I just use
> > > > String vars instead of enclosing the string in double quotes. One
> > > > problem I
> > > > have with PreparedStatements is they don't go away until you
> > close the
> > > > connection. I've tried the close() and setting = null but they
> > > > persist. My
> > > > knowledge is not absolute so, please correct me if I'm wrong
> > > > (cause I want
> > > > to be right:-)
> > >
> > >
> >
> ________________________________________________________________________
> ___> To unsubscribe, send email to [EMAIL PROTECTED] and include in
> the body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives: http:
> > > 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:
> > Resources: http://java.sun.com/products/servlet/external-
> > resources.htmlLISTSERV 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
