At 02:03 PM 4/29/00 -0400, you wrote:
>The following should work for both Access and SQL Server.
>
>Since Now() is already in ODBC format, inserting it is dead simple:
>
><CFQUERY NAME="qryInsertDateTime" DATASOURCE="some_dsn">
> INSERT INTO some_table (column_name)
> VALUES (#Now()#)
></CFQUERY>
Doesn't INSERT here for SQL Server 7 sp1, NT4sp6a
I need to use VALUES (#CreateODBCDateTime(Now())#)
best, paul
PS> My recollection is my above is needed for Access, too.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
