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
> 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
> 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