Hi,
I finally figured it out. All it took was to change the field types in my
database (I am using PostgreSQL). By common sense I desgined the fields to be
"date" and never even thought that it would cause the problems. So I just
re-designed the database by changing "date" fileds to "varchar" and everything
works perfect.
Thanks for help,
Bart
Hi,
> I have a problem with the date field being pulled from the database
> using FlashForms. I am able to send the date across such as 03/01/07
> but when I am looking up my date on the grid and form below the date
> shows up in the long format such as March 1 00:00:00 GMT-0600 2007 I
> have been trying mask, dateformat and none of them worked.
> This is what I am currently using
> <cfinput type="datefield" required="yes" name="date_assigned"
> label="Date Assigned: " width="250" size="30" maxlength="30"
> bind="{CoursesGrid.dataProvider[CoursesGrid.
> selectedIndex]['date_assigned']}" >
> I am trying to get it formatted as mm/dd/yyyy when pulling from the
> database.
> Has anybody been able to solve this?
> Please help,
> Bart
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2669
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
