macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: The CFINPUT TYPE=DATEFIELD does not want to accept the date from the

Subject: Re: The CFINPUT TYPE=DATEFIELD does not want to accept the date from the database
From: GArlington
Date: Mon, 13 Aug 2007 02:04:33 -0700
Newsgroups: macromedia.coldfusion.cfml_general_discussion
On 12 Aug, 20:51, "cyber fyb" <[email protected]> wrote:
> I got a weird problem which I guess can be just a way to explain to the server
> how to interpret the value. I am using ColdFusion 8 with SQL 2005 Express. In
> my table, the field is a DATETIME field and shows the date with time (eg.
> 2007-07-23 00:00:00).
>
>  In my form, when I am adding using the DATEFIELD as the type for CFINPUT, it
> records the date correctly. But when I use the EDIT.cfm form and try to put 
> the
> value from the database into the DATEFIELD CFINPUT, the server generate an
> error. Here is the error:
>
>  2007-07-23 00:00:00/0 is an invalid date or time string.
>
>  Of course, I tried many things but mostly I tried to force the format of the
> date with DATEFORMAT(qGetNewsInfos.dtIssued, 'mm/dd/yyyy') and many more 
> format
> but without success.
>
>  Is anybody know the trick how to use a date into a <CFINPUT TYPE=DATEFIELD>?

Dump the data that you are trying to assign to the field...
Is it '2007-07-23 00:00:00/0'? Then find where the '/0' is coming
from...


<Prev in Thread] Current Thread [Next in Thread>