On Dec 29, 2006, at 7:53 PM, John Siracusa wrote: > If you jut want the value of now() in isolation, plain DBI is the > way to go. > (Wrap the code in a function or class method somewhere to hide the > gory DBI > details.)
the problem I see is that you can run into issues where NOW() is transaction specific -- like in Postgres personally, i manage transactions outside of Rose, and then have a helper class create new rose::db objects and pass in the correct db handle as needed . i imagine you could do something like the reverse -- grab a rose DB object and then use that db handle to query the time you could also try creating a new rose::db::object class of sql helper items with 'result' as the only column-- then give it a manager class and have functions select your 'result' into the 'result' field. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | RoadSound.com - Tools For Bands, Stuff For Fans | Collaborative Online Management And Syndication Tools | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ------------------------------------------------------------------------- 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
