Jillian Carroll wrote: > > <cfquery name="update" datasource="#DSN#"> > UPDATE attendee > SET > <cfif IsDate(Trim(Form["regreceived" & Indx]))> > regreceived = > #CreateODBCDate(ParseDateTime(Trim(Form["regreceived" & Indx])))#, > <cfelse> > regreceived = NULL, > </cfif> > </cfquery> > > I can't find what's wrong... ideas?
The comma. But I would use: <cfquery name="update" datasource="#DSN#"> UPDATE attendee SET regreceived = <cfqueryparam cfsqltype="cf_sql_date" value="#Trim(Form["regreceived" & Indx])#" null="#not IsDate(Trim(Form["regreceived" & Indx]))#"> </cfquery> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4