On Tue, Dec 26, 2006 at 09:28:50AM -0800, Dan Wierenga wrote: > Whoops, sorry all, that was meant to be a private reply to Tim.
My fault. My original was meant for Dan. Sorry. Tim. > Dan Wierenga wrote: > > 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 > > > > ------------------------------------------------------------------------- > 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
