I'm trying CFMX with PostgreSQL.
Good News:
1) The query limit problem is over!! Yuppie. Now, you can insert how much
text you want in text fields
Bad News:
1) Special chars (eg: \) are not properly ecaped. The query I posted so
many times continues to fails.:-((
(eg: String to insert via <input>: this is a test \' hello world)
2) Now, the worst ! I can't work with accented characters like �����.
From CFAM in JDBC URL I wrote:
jdbc:postgresql://localhost/my_db?charSet=ISO8859_1
and in Application.cfm:
<cfprocessingdirective pageencoding="ISO8859_1">
<CFSCRIPT>
setEncoding("FORM", "ISO8859_1");
setEncoding("URL", "ISO8859_1");
</CFSCRIPT>
I can retrive data correctly form PG but when I try to insert data via form
(request method POST) all accented characters are transformed.
Changing the carSet in UTF-8 doesn't resolve the problem. I think this time
is not a driver issue, but a cfmx problem because using the driver directly
from Java doesn't produce the error.
I hope to solve this problem ASAP otherwise I have to stay with CF 5.
Bye.
--------------------------------------------------
FABIO SERRA - faser(at)faser.net
PGP available
--------------------------------------------------
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
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.
