Insert into Medium Time Date/Time field in Access
Posted on 2003-11-12
hi. I'm using cfinput to insert a time into an access database. I was able to make it work on my system, but when i upload it to my server, it doesn't work. A time gets inserted, but its 12:00 AM for every one.
Here is the cfinsert statement:
<CFINSERT datasource="db_44" TABLENAME="schedule" DBTYPE="ODBC" FORMFIELDS="completed,opponent,opp_short,gamedate,home_away,location,gametime">
Here is the cfinput:
<cfinput name="gametime" type="text" size="25" required="no">
I have a medium date field in the same form (gamedate) and i had to input the date into the <cfinput> tag as mm/dd/yyyy. Is there a format i need to follow other than hh:mm tt (9:00 PM)?
I tried changing the cfinput to input. Didn't work either.