You should be able to use: #myParam.myList[1].myProperty# Cheers, Clinton
On Tue, 28 Dec 2004 14:02:13 -0600, Karen Koch <[EMAIL PROTECTED]> wrote: > Thank you. One more vital question: How does one refer to a property of an > object in a list? Is there simply some kind of dot notation for > dereferencing? I have not found any examples of this. > > -----Original Message----- > From: Clinton Begin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 28, 2004 12:44 PM > To: [email protected] > Subject: Re: Update on a list of POJOs -- what's the best approach? > > Hi Karen, > > > Is my best bet in writing the statement itself, to pass the list in as the > > parameter and then iterate over it to build a WHERE clause that uses IN > ()? > > Yes, for sure. > > > Also, I haven't seen one, but is there a way to pass multiple > > parameters to a statement? > > No, not through an additional method parameter. You can pass multiple > parameters as Map entries or JavaBeans properties (the latter is > preferred, but a few more lines of code). > > Clinton > > On Tue, 28 Dec 2004 11:51:46 -0600, Karen Koch <[EMAIL PROTECTED]> wrote: > > > > > > > > I'm not quite certain how this problem is best approached using SQLMaps: > > > > > > > > I want to implement a sort of "mass update" feature by which the database > > records that correspond to objects in a java.util.List have 3 fields set. > > All objects in the list will have the 3 fields set to the same 3 values. > > > > > > > > Is my best bet in writing the statement itself, to pass the list in as the > > parameter and then iterate over it to build a WHERE clause that uses IN > ()? > > > > > > > > Also, I haven't seen one, but is there a way to pass multiple parameters > to > > a statement? Ideally, I want to pass the list itself and also a single > > integer that will be used to update one of the three fields and look up > the > > values to update the other two fields. > >
