ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brice Ruth <bdr...@gmail.com>
Subject Re: I guess one can not parameterize the table name
Date Tue, 28 Jun 2005 17:52:59 GMT
You might want to add the bit about this being a performance impactor, into 
the Wiki page. Would you mind?
 Brice

 On 6/28/05, Nathan Maves <Nathan.Maves@sun.com> wrote: 
> 
> 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
> 
> 
> 


-- 
Brice Ruth
Software Engineer, Madison WI

Mime
View raw message