Whoops, sorry all, that was meant to be a private reply to 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
