I have been pulling my hair out with the above method trying to update a record. When I try to update via a peer object the update method above does not produce any changes in the DB. The object passed into the method has the same parameters as the one below.
When I trace the calls to the db it seems the CAT_ID is null even though the object has the correct cat id.
After hours of trying with the object I used a criteria object. doing it via a criteria object works fine.
Criteria crit = new Criteria();
crit.add(EquipmentCategoryPeer.CAT_ID, catid.intValue());
crit.add(EquipmentCategoryPeer.CAT_DESC,(String)equipcatForm.get("catdesc"));
EquipmentCategoryPeer.doUpdate(crit);
My questions:
1) is this a known problem or has this been experienced before ? I have searched newsgroups and mailing list and can't find anything.
The problem is most likely that you are not specifying the database name in your schema.
2) what's considered "best practice" doing updates via criteria or table objects ?
Via table objects.
Scott
-- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
