[ic] Date selector Widget, does it work?

Bill Carr bill at worldwideimpact.com
Tue Aug 7 15:04:41 EDT 2007


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



More information about the interchange-users mailing list