tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Sabourdin <zouy...@yahoo.com>
Subject Re: before I go insane
Date Thu, 14 Sep 2000 10:31:18 GMT
  String preSql = "INSERT INTO blocNotes
(blocNotes.titleBlocNote, blocNotes.coreBlocNote,
blocNotes.idPersonnes) VALUES (?,?,?)";
        PreparedStatement pstmt =
myConnInstance.prepareStatement(preSql);
        pstmt.setString(1, titleBlocNote);
        pstmt.setObject(2, coreBlocNote);
        pstmt.setInteger(3, userId);
        pstmt.executeUpdate(); 
--
;-)
that does it for You
--- Luis Andrei Cobo <valis@megapathdsl.net> wrote:
> Can someoen please tell me how to escape a single
> quote in a request
> parameter?
> 
> for example, a text field paramter was " john's
> books" and I need to put
> that in a sql statement as" john''s books" ( two
> singlequotes)
> 
> how do I do this?
> 
> replace('\u2032','\u2032\u2032'); doesnt seem to
> work
> 
> Luis
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/

Mime
View raw message