First of all, don't use CFINSERT. Write your own SQL scripts.
Second, make sure that the data being inserted into the date/time field is
actually a date/time object. In this case, it is not.
The code below illustrates how this works properly with a date/time field:
--------------------snip----------------------
<cfparam name="send_time" default="">
<cfoutput>
<cfif send_time neq "">
#CreateODBCTime(send_time)#
<br>
<br>
</cfif>
<form action="#script_name#" method="post">
<select name="Send_Time" size="1">
<OPTION VALUE=""></OPTION>
<option value="01:00 PM">01:00 PM</option>
<option value="02:00 PM">02:00 PM</option>
<option value="03:00 PM">03:00 PM</option>
<option value="04:00 PM">04:00 PM</option>
</select>
<input type="submit">
</form>
</cfoutput>
--------------------snip----------------------
------------------------------------
Mark Warrick - Fusioneers.com
Email: [EMAIL PROTECTED]
Phone: 714-547-5386
http://www.fusioneers.com
http://www.warrick.net
====================================
> -----Original Message-----
> From: Shally [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 30, 2001 8:27 AM
> To: CF-Talk
> Subject: Insert form
>
>
>
> Hi Every one,
> I have an Insert form where there is an option of
> lists to be selected by the user.
> <select name="Send_Time" size="1">
> <OPTION VALUE="[Not Answered]"></OPTION>
> <option value="0100">0100</option>
> <option value="0200">0200</option>
> <option value="0300">0300</option>
> <option value="0400">0400</option>
> </select>
>
> I am able to insert all the other values in the
> database with the help of <Cfinsert> tag but not the
> above selection.
> Database used is Access and the datatype of the field
> is "Date/time".I even tried with "Text" datatype but
> it didn't work.
>
> Please help.
>
> Shally
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
