[Fwd: How to pass a parameter to collection property?]

I would like to pass an additional parameter to filter a collection property. I will use an example from iBATIS-SqlMaps-2.pdf, page 27.   How can i select a category with products with certain price specified by parameterX?   select * from PRODUCT where PRD_CAT_ID = #value# and PRD_PRI

Re: how can i get attribute from inbed object?

Never mind, just noticed there isn't a comma between min and max values (which is terrible on the part of the API designers). You can get ibatis to print the SQL it's using after parsing inline parameters.  That might help you find the problem. clinton On 12/1/05, Clinton Begin <[EMAIL PROTECTED

Re: how can i get attribute from inbed object?

You're missing a comma     insert into feature_set (format_id, projection_name, bounds) values(#format.id#, #projection.name#, box3d('BOX3D($bounds.minX$ $bounds.minY$, $bounds.maxX$ , $bounds.maxY$)')) On 12/1/05, David Moss <[EMAIL PROTECTED]> wrote: Hi,Has anyone managed to

Re: how can i get attribute from inbed object?

Hi, Dave    #format.id# and #projection.name# can work well if you has private attribute and public accessors.  please pay attention to your accessors, it must be realized in most simple way,without any actions except set and return,just like this:    private Object attribute;    public void setAt

Re: how can i get attribute from inbed object?

Dave, Can you also give us the parameter class code? Without more information on this class there is no way to tell. Nathan On Dec 1, 2005, at 10:26 AM, David Moss wrote: Hi, Has anyone managed to get this to work? I'm trying to do something very similar, but it's not working. I have a

AW: how can i get attribute from inbed object?

Hi Dave is the following snippet exactly the same as in the SqlMap? If so then the parser might get confused about the carriage return within the string starting at box3d(' insert into feature_set (format_id, projection_name, bounds) values(#format.id#, #projection.name#, box3d

Re: how can i get attribute from inbed object?

Hi, Has anyone managed to get this to work? I'm trying to do something very similar, but it's not working. I have a class IProjection with a property name. If I try the following map insert into feature_set (format_id, projection_name, bounds) values(#format.id#, #projection.name#,

Re: utilizing nested iterate tags in SQL Map xml file -- is it supported?

Hi Jeff, Thanks for the quick answer. We have an acceptable work-around by providing a getter method on the parameter object that returns a list of maps with a map for every combination we need (for example (team id,player id)). We then use the iterate tag to iterate over the list of maps. (Swe

Re: utilizing nested iterate tags in SQL Map xml file -- is it supported?

Hi Mark,   The DTD allows nested iterate tags, but they don't really work the way you (and I) would like them to.  The problem is that there is no method for tags inside an iterate tag to refer to the current object in the iterate loop (like the "var" property of JSTL's forEach tag).  So, even thou

tag

Hello when they are two tags with the same id, the last read is the one ! but may be a warning will be usefull to say that id already exists... ;-)

Re: How to return a List of record?

Boy, was my first answer off base! Sorry about that. If I may try again... Sure, you can use the same select to retrieve both a record (via queryForObject) and a list containing one record (via queryForList). - gary At 08:30 PM 11/30/2005, you wrote: I want to get a List of records by get

Re: Throttled

Clinton, I'll do as you suggest and attach the file. Thanks for your help. Jeff --- Clinton Begin <[EMAIL PROTECTED]> wrote: > I believe the fix you've made this time (i.e. commit > in started or committed > state) is acceptable, and probably something we > could include in the base. > > Can y

Re: Reg queryForList (returns back a list of empty objects)

Try this: Larry On 12/1/05, Sathish S <[EMAIL PROTECTED]> wrote: > Hi All, > I wanted to query an unknown table at the runtime ie the user will > select a table from the list of tables (These tables are created dynamically > at the runtime and I am not sure about the table definition) an

another ibatis article

http://osnews.com/comment.php?news_id=12829

Reg queryForList (returns back a list of empty objects)

Hi All,     I wanted to query an unknown table at the runtime ie the user will select a table from the list of tables (These tables are created dynamically at the runtime and I am not sure about the table definition) and would like to see the records. I am using the method queryForList("statementNa