Question
preservesinglequotes not working ?
I work with CF MX V7,
I use this code, and the SQL update failed : (with a single quote in the text)
<cfset des=" test test ' test ">
<cfquery name="insert_prod" datasource="#boutique_datasource#">
update produits_lang
set description='#preservesinglequotes(des)#'
where id_prod=#form.id_prod# and prod_lang_code='#lang_code#'
</cfquery>
Error message : missing operator etc....
It does not allow the single quote in the text !
Help, thanks for any solution ?
Pierre.
I use this code, and the SQL update failed : (with a single quote in the text)
<cfset des=" test test ' test ">
<cfquery name="insert_prod" datasource="#boutique_datasource#">
update produits_lang
set description='#preservesinglequotes(des)#'
where id_prod=#form.id_prod# and prod_lang_code='#lang_code#'
</cfquery>
Error message : missing operator etc....
It does not allow the single quote in the text !
Help, thanks for any solution ?
Pierre.
AdChoices