I suspect that it is the _time that is doing it, _time is a validation rule
which basically says if there is a field named "send" make sure it is a
valid time. As such, <CFINSERT> is ignoring that field. You'll have the same
problem with _date _float _range etc. Try renaming the field to something
else, and it should work.
--- Ben
-----Original Message-----
From: Shally [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 11: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
