Thread: preparedStatement
Hey guys, Did you change anything in preparedStatement since 7.0x? Does it escape ' still? I have tracked my mysterious ' problem down to the fact that before (tomcat 3.x, postgresql + jdbc 7.0x) all ' inserted/selected into/from the database were escaped correctly. Now (tomcat4.0.2, postgresql + JDBC 7.2) they aren't. After crawling for hours through the forums over at Sun it seems that preparedStatement should look after single ' in queries. Waiting impatiently on your views All JSP code generated by Ultradev of course Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html