But if you want to do it this way, you have to escape single quotes when
you create your SQL.
<cfset thesql="update data set
data = ''","''","ALL")#',
data_f = '#Replace(form.EditorDefault2,"'","''","ALL")#'
where nav_id = #form.nav_id#">
> -----Original Message-----
> From: Daniel Farmer [mailto:[EMAIL PROTECTED]
> Sent: donderdag 22 januari 2004 19:56
> To: CF-Talk
> Subject: Re: some errors...
>
> How could I integrate cfqueryparam in the following statement?
>
> <cfset thesql="update data set data = '',
> data_f = '#form.EditorDefault2#' where nav_id =
> #form.nav_id#"> <cfmodule template =
> "../dbaccess_code/dbaccess.cfm" sql="#thesql#" qname="getit">
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
