I have dealt with this case before. I don't think it's the replace. But
rather that the cfset will not replace pattern_name just like that.
Try <cfset tmp_pattern_name=...> and then on your values instead of
'#Form.pattern_name#' use '#tmp_pattern_name#'
I hope it helps.
<Jaime/>
> -----Original Message-----
> From: Michael Wilson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 01, 2000 3:32 PM
> To: CF-Talk
> Subject: RE: " symbol Vs. "
>
>
> Hi,
>
> Thanks for taking time to try and help me with this stuff.. but ( and you
> knew it was coming didn't you?) I still can't get it to work correctly.
>
> This is what I have on my action page as per your instructions.
>
> <CFSET pattern_name = replace(pattern_name, '"', '"', 'all')>
>
> <cfquery name="AddPattern" datasource="dbcms" dbtype="ODBC">
> INSERT INTO tblpatterns <CFSET pattern_name = replace(pattern_name, '"',
> '"', 'all')> (pattern_name, pattern_num, pattern_price, pattern_cat,
> pattern_pic, pattern_des)
> VALUES
> ('#Form.pattern_name#','#Form.pattern_num#','#Form.pattern_price#'
> ,#Form.pat
> tern_cat#,'#Form.pattern_pic#','#Form.pattern_des#')
> </cfquery>
>
>
> <html>...
>
> What am I missing or doing wrong? The insert executes and the
> information is
> entered into the database, however it is still the " symbol
> rather than the
> " that get inserted into the database.
>
> Thanks,
>
> Mike
>
>
> > -----Original Message-----
> > From: BORKMAN Lee [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 01, 2000 5:41 PM
> > To: CF-Talk
> > Subject: RE: " symbol Vs. "
> >
> >
> > Just put it in the form-handler (action) page, immediately before
> > you do the
> > INSERT or UPDATE.
>
> ------------------------------------------------------------------
> ------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
