ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <duvelbier-tsm...@yahoo.com>
Subject Re: Output of SQL-task
Date Mon, 02 May 2005 11:35:29 GMT
Tx Ivan for the work around ... 
It is however a bit frustrating to have a neat tool and then to have to mess about to do smthg
trivial. Especially that one can remove the ResultSet columns header with a simple switch
...

\T,



--- Ivan Ivanov <rambiusparkisanius@yahoo.com> wrote:
> Hello,
> 
> --- duvelbier-tsmets@yahoo.com wrote:
> > My only problem is that the ouptu is as follows :
> > <snip>
> > 9002
> > 9003
> > 9005
> > 9006
> > 9000
> > 9001
> > 
> > 0 rows affected
> > </snip>
> > 
> > How can I remove the last line... indicating the nbr
> > of lines impacted ... ?
> 
> It does not come to my mind how to configure sql task
> to not ouptput its last line; anyway you can copy the
> output file with tail filter skiping the last line:
> 
> <project>
>   <copy file="outputfile" tofile="outputfile1">
>     <filterchain>
>       <tailfilter skip="1"/>
>     </filterchain>
>   </copy>
> </project>
> 
> Another way is to replace the string "O rows affected"
> with the empty string:
> <project>
>   <replaceregexp file="output">
>     <regexp pattern="0 rows affected"/>
>     <substitution expression=""/>
>   </replaceregexp>
> </project>
> 
> HTH Ivan
> 
> > 
> > Tia,
> > 
> > \T,
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Sports - Sign up for Fantasy Baseball. 
> http://baseball.fantasysports.yahoo.com/
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
> 
> 

Any fool can write code that a computer can understand. 
Good programmers write code that humans can understand.
                                                   Martin Fowler 
T. : +32 (0)2 742 05 94
M. : +32 (0)497 44 68 12

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message