Philip,
I tried this...
<cfquery name="Insert" datasource="lsars">
insert into taavon.history
(lid,summary,completedby,assignedby,comptime)
values ('#url.lid#', '#form.summary#','#url.assigned#','',#Now()#)
</cfquery>
and got an error...
ODBC Error Code = 22008 (Datetime field overflow)
[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 - Syntax
of date,
time, or timestamp value not valid.
The error occurred while processing an element with a general
identifier of (CFQUERY),
occupying document position (9:1) to (9:42).
Any ideas?
Philip Arnold - ASP wrote:
>
> > Any one have a custom tag that retrieves both the DateFormat (Now()) and
> > TimeFormat (Now()) as one function that can be inserted into a database?
>
> I assume you've got your field as a DateTime format - if not, then change it
> to be DateTime
>
> Also, try to use the database native functions - Now() for Access and
> GetDate() for SQL Server - it'll be faster and cleaner than getting CF to do
> the work
>
> If you really want to use CF to do it, then use
> #CreateODBCDateTime(Now())# - assuming you're talking to the database ODBC
> and not OLE DB
>
> Try not to use DateFormat and TimeFormat into a format that "looks" right
> for you - the database server may look at is as just some text and produce
> an error - if you're fixed on the idea of using a set DateFormat, then use
> one that isn't ambigious, like "d mmm yyyy", that way, it can't be
> confused - DEFINITELY avoid formats like "mm/dd/yyyy" as some databases may
> interpret it as "dd/mm/yy" (depending on nationalisation)
>
> HTH
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
> ------------------------------------------------------------------------------
> 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.
