Hi,
Maybe I am way off base... I'm still learning, but I do something
similar on my site and this works fine for me. Here's part of the code:
Form stuff
///////////////
<input type="hidden" name="CodeDate" value="#DateFormat(todayDate,
"m/d/yyyy")#">
Insert stuff
///////////////
<CFQUERY NAME="AddCode" DATASOURCE="#request.dsn#">
INSERT INTO codes(CodeDate)
VALUES ('#Form.CodeDate#')
</CFQUERY>
Is this different from what you are trying to do?
Mike
> -----Original Message-----
> From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 09, 2001 3:21 PM
> To: CF-Talk
> Subject: Re: date time problem
>
>
> Same thing, right truncation. Funny thing is I have form I
> use for updating the same table, and everything works great.
> The code is identical except for it's an update and not a
> insert. hmmmmmmmmmmmmmm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
