On 1/5/07 11:29 PM, John Siracusa wrote: > On 1/5/07 10:53 PM, Neal Clark wrote: >> my $sql = "SELECT * FROM malware_logs"; >> $Rose::DB::Object::Manager::Debug = 1; >> my $iterator = MalwareLog::Manager->get_objects_iterator_from_sql($sql); > > Just an aside: in the case of this simple query, there's no reason to use a > *_from_sql() Manager method.
...and I'll add that there's rarely ever a reason to use the *_from_sql() methods unless you really, really like writing your own SQL, or are doing something very fancy that requires you to do so. (The "normal" Manager methods will also deflate/coerce/format "rich" query parameter values and can fetch columns from multiple tables using arbitrary-depth JOINs, whereas the *_from_sql() methods can only fetch columns from the primary table. So in a sense, the "normal" Manager methods are actually a bit more "fancy" than the *_from_sql() ones.) -John ------------------------------------------------------------------------- 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
