Is there any way to find my position while iterating through a collection in the sqlMap file. For example, I want to do something like this:
<iterate property="attributes" > ,( SELECT TEMP_PA.PRODUCT_ID FROM PRODUCT_ATTRIBUTES TEMP_PA, ATTRIBUTES TEMP_A WHERE ( TEMP_A.ATTRIBUTE_ID = TEMP_PA.ATTRIBUTE_ID AND TEMP_A.NAME = #attributes[].name# <iterate property="attributes[].values" prepend=" AND ( " close=" ) " conjunction=" OR " > <isNotEmpty property="attributes[].values[].value"> TEMP_PA.VALUE = #attributes[].values[].value# </isNotEmpty> </iterate> ) ) TEMP$attributes[].name$_{POSITION_IN_ITERATION} </iterate> I may have multiple attributes with the same name, so I need something that will allow me to uniquely name this alias. Anyone have any ideas? Thanks, Chris