[transfer-dev] Re: Update multiple records

2009-06-02 Thread Bob Silverberg
You cannot do that with Transfer, not in the way you suggest anyway.
Transfer works with objects, not table rows, so you'd have to ask Transfer
to get each object, update its property and then ask Transfer to save the
object.  You could use one of the listXXX methods to get a query that
contains the records you are interested in, and then loop over that query,
getting each object, etc.

If the expected number of records is small this will probably be fine, but
if it may be a large number then you'd probably be better off just coding it
in SQL.  If you do go that route (using SQL) don't forget to discard the
objects from the cache after you update them - otherwise your cache will be
out of synch.

Cheers,
Bob


On Tue, Jun 2, 2009 at 6:49 PM, stephend stephend...@gmail.com wrote:


 Hi,

 Been using for transfer for awhile now but this is the first time I
 have had to update a group of records in a table.
 This is easy in straight SQL but how do you do it with transfer.

 eg. Update tableName set defaultRec = Y where user = x

 Thanks.

 



-- 
Bob Silverberg
www.silverwareconsulting.com

--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en
-~--~~~~--~~--~--~---



[transfer-dev] Re: Update multiple records

2009-06-02 Thread stephend

Hi Bob,

Thanks for the reply, as it is a small list of records I have taken
the route you suggested using listByQuery() and it works fine.

Cheers
Stephen

On Jun 3, 10:27 am, Bob Silverberg bob.silverb...@gmail.com wrote:
 You cannot do that with Transfer, not in the way you suggest anyway.
 Transfer works with objects, not table rows, so you'd have to ask Transfer
 to get each object, update its property and then ask Transfer to save the
 object.  You could use one of the listXXX methods to get a query that
 contains the records you are interested in, and then loop over that query,
 getting each object, etc.

 If the expected number of records is small this will probably be fine, but
 if it may be a large number then you'd probably be better off just coding it
 in SQL.  If you do go that route (using SQL) don't forget to discard the
 objects from the cache after you update them - otherwise your cache will be
 out of synch.

 Cheers,
 Bob

 On Tue, Jun 2, 2009 at 6:49 PM, stephend stephend...@gmail.com wrote:

  Hi,

  Been using for transfer for awhile now but this is the first time I
  have had to update a group of records in a table.
  This is easy in straight SQL but how do you do it with transfer.

  eg. Update tableName set defaultRec = Y where user = x

  Thanks.

 --
 Bob Silverbergwww.silverwareconsulting.com
--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en
-~--~~~~--~~--~--~---