ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sven Boden <list...@pandora.be>
Subject Re: Temp table
Date Mon, 20 Mar 2006 21:56:20 GMT

Probably not, most drivers want a single SQL statement when using 
PreparedStatements.

Regards,
Sven

Suman.Mishra@ubs.com wrote:

>Hi,
>
>Can I use something like this -
>
><select id = "xxx" resultClass="ABC1" parameterClass="ABC2">
>
>Select * from T where <>
>
>insert into #temp
>Select * from T where <>
>
>Select * from #temp
>
></select>
>
>
>
>Regards,
>Suman Mishra
>203-719-1698
>
>
>
>  
>
>------------------------------------------------------------------------
>
>
>Visit our website at http://www.ubs.com
>
>This message contains confidential information and is intended only 
>for the individual named.  If you are not the named addressee you 
>should not disseminate, distribute or copy this e-mail.  Please 
>notify the sender immediately by e-mail if you have received this 
>e-mail by mistake and delete this e-mail from your system.
>
>E-mail transmission cannot be guaranteed to be secure or error-free 
>as information could be intercepted, corrupted, lost, destroyed, 
>arrive late or incomplete, or contain viruses.  The sender therefore 
>does not accept liability for any errors or omissions in the contents 
>of this message which arise as a result of e-mail transmission.  If 
>verification is required please request a hard-copy version.  This 
>message is provided for informational purposes and should not be 
>construed as a solicitation or offer to buy or sell any securities or 
>related financial instruments.
>  
>


Mime
View raw message