Thats got it - got confused about TimeStamp /DateTime /Date (just moved from Access :)
Thanks! T On 12 Jul 2007, at 15:46, Charlie Griefer wrote: > cf_sql_timestamp as the cfsqltype? > > On 7/12/07, Tom King <[EMAIL PROTECTED]> wrote: >> Hi all, >> this is driving me nuts: >> >> I'm trying to insert a date/time into a mysql database: >> >> the row is set up as datetime, NULL as default; >> >> I;m trying to insert from a form where I have drop downs which give >> me the various values; >> >> The values are definitely being passed from the form to the CFC; >> the time stamp I'm passing in is valid, and the DATE always changes, >> but the Time value is always inserted at 00:00:00 >> >> >> <cfscript> >> //Create Valid Date Time Objects >> ThisStartDate=CreateDateTime(year(form.EventStart), >> month(form.EventStart), day(form.EventStart), form.starthour, >> form.startmin, >> 00); >> ThisEndDate=CreateDateTime(year(form.EventEnd), >> month(form.EventEnd), day(form.EventEnd), form.Endhour, form.Endmin, >> 00); >> </cfscript> >> >> This is the SQL: >> >> UPDATE tblEvents >> SET >> EVENTNAME = <cfqueryparam value="#form.EventName#" >> cfsqltype="cf_sql_varchar">, >> EVENTSTART = <cfqueryparam value="#ThisStartDate#" >> cfsqltype="cf_sql_date">, >> EVENTEND = <cfqueryparam value="#ThisEndDate#" >> cfsqltype="cf_sql_date">, >> WHERE EventID = <cfqueryparam value="#form.eventid#" >> cfsqltype="cf_sql_integer">; >> >> >> Help??? >> >> >> Thanks >> >> >> T >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
