On 2/28/07 7:42 PM, Fred Cox wrote:
> I haven't seen anything that indicates I can use a
> subselect in the set clause of RDBOM->update_table.
Yeah, there's no real support for subselects except as literals, and even
that only seems to work in the where clause due to a bug. I'll try to fix
the bug, after which it'll be something like this:
My::Manager->update_whatevers(set => { foo => \'(select ...)' },
where => [ ... ]);
In the meantime, a custom Manager method that uses DBI internally is
probably the way to go.
-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
