yes, use the $myProperty$ syntax. Brandon
On 4/14/05, Abeyratne, Sam <[EMAIL PROTECTED]> wrote: > > > > I have statement that looks like > > > > Select * from [EMAIL PROTECTED] > > > > UNION ALL > > > > Select * from [EMAIL PROTECTED] > > > > UNION ALL > > > > Select * from [EMAIL PROTECTED] > > > > . > > . > > . > > > > > > I tried to use a sqlmap that states: > > > > <iterate conjuction="UNION ALL"> > > Select * from [EMAIL PROTECTED] > > </iterate> > > > > Passing a list containing [database1, databaee2, database3, etc] and this > doesn't seem to work. As I understand this is not possible in the current > ibatis version. > > > > If this is the case, I was wondering if I could make this change in java and > pass the updated sql to the ibatis framework. Is this possible? How would I > pass an entire sql statement? > > > > Thanks much! > > Sam