Who is responsible to escape special chars in a query? ColdFusion with <cfquery> or the odbc driver? I have a problem with the newer driver for PostGresSQL (unixodbc ) and the newer PostGresSQL version (7.1.3). All is running with CF 5 on a supported Linux Distro (Suse 7.2). If I made an insert or update query an error occured if there is a backslash and a quote ( \' ) combination
<cfset text = " \' " <cfquery> update table set text = '#text#' </cfquery> Error while executing the query (non-fatal); ERROR: Unterminated quoted string The same thing doesn't happen with other database. AFAIK in ColdFusion there isn't any function like the PHP addslashes($text); Bye. -------------------------------------------------- FABIO SERRA - faser(at)faser.net PGP available -------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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.
