ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: I guess one can not parameterize the table name
Date Tue, 28 Jun 2005 16:53:35 GMT
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


Mime
View raw message