I probably should be able to figure this out on my
own, but if I'm barking up the wrong tree, I don't
want to spend the time, and searching hasn't helped.

I want to update a row in the table using the result
of a subselect as a value in one round trip.

In DBI, I would do this:

prepare( 'update make_model_years set
performancerating=(select sum(perf)/count(*) from
ratings where year=? and makeid=? and modelid=?) where
year=? and makeid=? and modelid=?' );
execute( 1973, 12, 185, 1973, 12, 185 );

I haven't seen anything that indicates I can use a
subselect in the set clause of RDBOM->update_table.

Thanks for any hints,

Fred


 
____________________________________________________________________________________
Food fight? Enjoy some healthy debate 
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367

-------------------------------------------------------------------------
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

Reply via email to