that is because you should put the WHERE clause at the end. You define what
you want to do, then define on which records you want to do it.
update hitclear
set cleardate = '#now#'
where table_id = 'reeldemand'
----- Original Message -----
From: Jacob <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 31, 2000 2:34 PM
Subject: Insert date and time into database
> I want to insert the date and time into a sql database. Here is want I am
> trying to do:
>
> <cfset now=createodbcdatetime(now())>
> <cfquery name="resettime" datasource="hits">
> update hitclear
> where table_id = 'reeldemand'
> set cleardate = '#now#'
> </cfquery>
>
> But, I get the following error:
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
> keyword 'where'.
> SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
> '2000-07-31 11:12:22'}'"
> Data Source = "hits"
> SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts
> '2000-07-31 11:12:22'}'"
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (7:1) to (7:44) in the template
file
> D:\html\counter.htm
> The specific sequence of files included or processed is:
> D:\HTML\COUNTER.HTM .
> Date/Time: 07/31/00 11:12:22
>
> I did have it working, but it was almost 8 lines of coding to set the date
> and time. I Would like to shorten the code to speed up the template.
>
> Any suggestions?
>
> Thanks
> Jacob
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
