Jochem van Dieten wrote:
>
> I have a problem with inserting strings into a PostgreSQL database using
> ColdFusion MX. Somehow the backslash is not identified as an escape
> character.
Macromedia Tech Support came with a solution for this one. The solution
is to use the ColdFusion MX <cfqueryparam> tag that uses the
PreparedStatement class. And, contrary to the native ColdFusion MX
<cfquery> tag, the PostgreSQL JDBC driver knows how to escape a backslash :)
Jochem