Hi Björn, I usually do retrieve list of IDs via OJB's getReportQueryIteratorByQuery and then run simple plain SQL to bulk update one field in each record by id.
Cheers, Vasily On 4/17/07, Björn Agel <[EMAIL PROTECTED]> wrote:
hi, say we have a table, where many thousands objects with about 30 fields are stored. Now I want to update only 1 of these 30 colums for a few hundred objects. Atm I retrieve every single object, change 1 value and store it ... What is the best solution for this task ? Is there anything similar to the "ALTER TABLE" statement ? with best regards, Björn Agel
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]