Just a reminder but using this is a performance hit.  I have never run into the case where using this type of statement is useful.  I find that copy and paste, then change the table name is much cleaner then select * from $table_name$

Personal Preference!

Nathan
On Jun 28, 2005, at 10:45 AM, Brice Ruth wrote:

Just add that attribute to your <select> definition in the XML. There isn't much else to give you ...
 
<select name="someName" other="" attributes="" can="" go="" here="" remapResults="true">
SQL goes here
</select>
 
Of course, order of attributes is not important at all ... this is just a sample!
 
On 6/28/05, Folashade Adeyosoye <shardayyy@gmail.com> wrote:

Thanks

 

Can you give a sample showing how to use remapResutls=true

 

Can't find it in the docs..

 

thanks

 

From: Nathan Maves [mailto: Nathan.Maves@Sun.COM]
Sent: Tuesday, June 28, 2005 11:44 AM
To: user-java@ibatis.apache.org
Subject: Re: I guess one can not parameterize the table name

 

Yes you can.

 

You need to use $value$ as well as use remapResutls=true

 

Nathan

 

On Jun 28, 2005, at 9:35 AM, Folashade Adeyosoye wrote:



Such as

select * from #value# where TheStatus = 'ACTIVE' and type = COLOR

shardayyy



 



--
Brice Ruth
Software Engineer, Madison WI