[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