Re: [ic] Date selector Widget, does it work?

[Bill Carr <suppressed>]

On Aug 7, 2007, at 1:58 PM, Tom Friedel - Ready Ink Incorporated wrote:

> I am trying to use this with Mysql and have tried DATE and   
> TIMESTAMP sql datatypes, and it does not seem to hold the value.  I  
> have not found any tables in the standard demo where this widget is  
> used.  Is it known to work or not work?
I could not get it to work out-of-the-box either. The following  
filter helped me.

CodeDef date_mysql Filter
CodeDef date_mysql Description Format values from date_time widget  
for MySQL
CodeDef date_mysql Routine <<EOR
sub {
        my $in = shift;
        $in =~ s/\0+//g;
        $in =~ s!(\d+)/(\d+)/(\d+):?(\d{0,2})(\d{0,2})!$3-$1-$2 $4:$5!;
        return $in;
}
EOR

-Bill


Bill Carr
Bottlenose - Wine & Spirits eBusiness Specialists
(877) 857-6700
http://www.bottlenose-wine.com
 Download vCard

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users