I'm looking at having the Corporate Systems codebase use it. Tim Bunce wrote: > Hi Dan. > > Is VC using RDBO? > > Tim. > > On Thu, Dec 21, 2006 at 03:45:25PM -0800, Dan Wierenga wrote: > >> When I retrieve a datetime field from a mysql database, it gets a "T" >> stuck in between the date and time fields of the return value (for >> "Time", I assume). Is there a way to suppress this and have a space in >> the field as I'm expecting? I don't see anything in the RDBO >> documentation about it. Looking in the DateTime documentation it seems >> that's standard for the DateTime::datetime function. I don't see anyway >> of overriding it from the Rose objects though, and I've learned to ask >> questions on mailing lists before I start poring through CPAN code. :) >> >> Example: >> >> mysql>SELECT user_name, expires from user; >> +---------------------------+---------------------+ >> | user_name | expires | >> +---------------------------+---------------------+ >> | [EMAIL PROTECTED] | 2006-12-21 13:59:59 | >> +---------------------------+---------------------+ >> >> using this code snippet: >> >> >> >> >> my $user = My::User->new(user_name => '[EMAIL PROTECTED]'); >> ##My::User has 'use base qw(Rose::DB::Object);' >> $user->load; >> print $user->expires; >> >> I get: >> 2006-12-21T13:59:59 >> >> >> Obviously, I could just s/T/ /g on any field that's a datetime in my >> database, but I'd like a cleaner way that will make all datetime fields >> return as they are in the mysql client. >> >> >> Any ideas? I've just started with RDBO so I apologize if I've missed >> something obvious or something covered in the docs. >> >> Thanks, >> Dan >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share your >> opinions on IT & business topics through brief surveys - and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ >> Rose-db-object mailing list >> Rose-db-object@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/rose-db-object >> > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Rose-db-object mailing list > Rose-db-object@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/rose-db-object >
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
