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!

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
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:



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


Can't find it in the docs..




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




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

Such as

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



Brice Ruth
Software Engineer, Madison WI