Sun, Jun 23, 2002 at 10:56:01PM +0200 scrivesti
> Using this driver I suggest you to use <cfqueryparam> in SQL
> INSERT, otherwise special chars are not properly ecaped :-(
> Anyone knows if there are the same problems with cfmx, jdbc and PostgreSQL?
I query postgres from pure java with statements such:
this.pstmt = cn.prepareStatement("INSERT INTO "+table +" (msgid, author,
subject)" + " VALUES (?,?,?)");
pstmt.setString(MSGID, a.msgID);
pstmt.setString(AUTHOR, a.from);
pstmt.setString(SUBJECT, a.subject);
or, after a SELECT:
int lastid = rs.getInt("lastid");
So I don't care about escapes, but the data-type is knwon from the statements
and I guess the driver fix them accordingly. I havn't tried with CFMX, but I would
suppose that the cfqueryparam will be needed, and translated in the above java
statements.
--
Rd
"Si giudicher� di te seguendo il colore delle tue tracce."
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
