[ic] date widget and mysql date field

[Ed LaFrance]

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
===============================================================