<cfquery name="Update_Test" datasource="#DSN#">
update mytest
set mytest_comment = <cfqueryparam value="#form.mytest_comment#" cfsqltype="cf_sql_varchar" />
where testid = #my_id#
</cfquery>
Change the sqltype accordingly.
- tim
Phil Evans spoke the following wise words on 27/06/2003 10:55 AM EST:
However, I've just migrated the site to a new server, Win 2000, MX (updater
unknown), SQL 2000 and if a user enters a single quote in a comment, it spits.
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
