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]
