On 9/20/06, David Christensen <[EMAIL PROTECTED]> wrote: > Is there is a way to get the raw SQL statement that the $object- > insert() would have generated, complete with interpolated bind > values?
Not really, because RDBO itself never interpolates bind values. It just passes them off to DBI, which then hands them off to the DBD, which then does the work of binding the values to the placeholders. You could perhaps force RDBO to inline all column values, then get the SQL by calling an undocumented internal method, but it would be ugly and unsupported. > Alternately, is there a way to get the parts as separate entities > (i.e., column names followed by bind values)? Check out the column_value_pairs() helper method: http://search.cpan.org/dist/Rose-DB-Object/lib/Rose/DB/Object/Helpers.pm#column_value_pairs -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
