Ahhhhhh...
I think I have it figured out now, or at least I've got it to work.
There was another page of code running before the info was uploaded to the
database with this bit of code on it:
<cfset thisdeldate = #CreateODBCDateTime(DateFormat(Form.delivery_date,
"dd/mm/yy"))#>
So I guess it was trying to ODBCDateFormat the date twice. Is that likely to
cause problems??
I have taken out the second bit of code, as mentioned above, and, touch
wood, it all seems tobe working again.
Many thanks to everyone who made a suggestion.
Cheers guys
Will
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2001 13:06
To: CF-Talk
Subject: RE: data nonsense
Micheal,
That generates an error. There is an extra " at the end, and you cannot have
commas inside the CreateODBCDate statement, as it only takes one argument.
This doesn't generate an error:
<cfset deldate = #CreateODBCDate(#form.year#/#form.month#/#form.day#)#>
However, when this date is entered: 25th May 2001, it creates this: {d
'1899-12-30'}!!
I have also tried this:
<cfset deldate = #CreateODBCDate(#form.day#/#form.month#/#form.year#)#>
Which makes 25th May 2001 as {d '1900-01-04'}, also wrong as you can see.
Any other ideas?
Cheers
Will
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2001 13:34
To: CF-Talk
Subject: Re: data nonsense
Throw away this:
<cfset formatdate = #DateFormat(intdate, "dd/mm/yy")#>
And Use this:
<cfset deldate = #CreateODBCDate(#form.year#,#form.month#,#form.day#)">
instead of this:
<cfset deldate = #CreateODBCDate(formatdate)#>
Thanks,
Michael Lugassy
Interactive Music Ltd.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
