Removing the quotes did not work. I do not deal with adding dates to a
database to much, but when I do, it takes me a while to figure it out. I
went with plan B below. It works. Fine for what I need.
<cfset dateclear = #dateformat(now(), "mm/dd/yy")#>
<cfset timeclear = #timeformat(now(), "hh:mm:ss")#>
<cfquery name="resettime" datasource="hits">
update hitclear
set cleardate = '#dateclear#', cleartime = '#timeclear#'
where table_id = 'reeldemand'
</cfquery>
thanks
Jacob
At 04:12 PM 7/31/00 -0400, you wrote:
><cfset now=createodbcdatetime(now())>
><cfquery name="resettime" datasource="hits">
>update hitclear
>where table_id = reeldemand
>set cleardate = '#now#'
></cfquery>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
