[ic] date widget and mysql date field

[Ed LaFrance]

At 11:42 AM 03/12/2002 -0700, you wrote:
>Does it store with YYYY-MM-DD ?  This field is also displayed, and
>displaying YYYYMMDD without any delimeter will look very odd.

This will fix it for display:

[convert_date][item-data table your_date_field][/covert_date]

- Ed L.




>-----Original Message-----
>From: interchange-users-admin@interchange.redhat.com
>[mailto:interchange-users-admin@interchange.redhat.com]On Behalf Of Ed
>LaFrance
>Sent: Tuesday, March 12, 2002 8:57 AM
>To: interchange-users@interchange.redhat.com
>Subject: Re: [ic] date widget and mysql date field
>
>
>At 10:42 PM 3/11/2002 -0700, you wrote:
> >Hello List,
> >
> >IC 4.8.3
> >
> >The date widget doesn't seem to like date typed fields in mysql.  The
>reason
> >I need to use the date type is to make sorting effectual on the date field.
> >Is the new dev. of IC solving this problem?  Is there a way I can update
> >Primitive.pm to get the date widget to read and write to a mysql date
>field?
> >
> >Thanks,
> >
> >Russ Mann
>
>Russ -
>
>Try making your date file char(8), then setup the UI to use the date widget
>for this field. I think you will find that the widget works correctly, and
>if you take a look at the raw field data you'll find that it is stored in
>the format YYYYMMDD automatically, which makes it suitable for sorting.
>
>- Ed L.
>
>
>===============================================================
>New Media E.M.S.               Software Solutions for Business
>463 Main St., Suite D          eCommerce | Consulting | Hosting
>Placerville, CA  95667         edl@newmediaems.com
>(530) 622-9421                 http://www.newmediaems.com
>(866) 519-4680 Toll-Free       (530) 622-9426 Fax
>===============================================================
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================