UPDATE healthnewsletters
SET publishdate = <cfqueryparam cfsqltype="cf_sql_date"
value="#publishdate#">,
title = <cfqueryparam cfsqltype="cf_sql_varchar" value="#title#">,
summary = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#summary#">,
author = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#Session.Fname# #Session.Lname#">,
newsletterbody = <cfqueryparam cfsqltype="cf_sql_clob"
value="#content#">
WHERE healthid = <cfqueryparam cfsqltype="cf_sql_number"
value="#healthid#">
</cfquery>
-----Original Message-----
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: dinsdag 23 december 2003 11:39
To: CF-Talk
Subject: RE: Date Errors in MX ?
Jochem
Thanks that seems to work, how would the syntax change for updating
database records ??
<cfquery datasource="#Application.DSN#" name="insert_query">
UPDATE healthnewsletters (healthid, publishdate, title, summary,
author, newsletterbody)
SET (
<cfqueryparam cfsqltype="cf_sql_number" value="#healthid#">,
<cfqueryparam cfsqltype="cf_sql_date" value="#publishdate#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#title#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#summary#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#Session.Fname#
#Session.Lname#">,
<cfqueryparam cfsqltype="cf_sql_clob" value="#content#">)
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
