I solved the problem by using:
<cfset auction_date="#DateFormat("#Now()#")#">
on the form page and then put '#auction_date#' in the insert statement.
However, I have another question now.
How can I create an SQL statement that will create a directory so my users
can upload to their own directory?
Thanks,
Rich
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]