ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From RADEMAKERS Tanguy <Tanguy.RADEMAK...@swift.com>
Subject RE: Output of SQL-task
Date Mon, 02 May 2005 18:51:38 GMT
Hello,

Try appending "set feedback off" at the top of your SQL script
(${unitTests.sql.dir}/query.sql)

/t 

>-----Original Message-----
>From: duvelbier-tsmets@yahoo.com [mailto:duvelbier-tsmets@yahoo.com] 
>Sent: Monday, May 02, 2005 1:35 PM
>To: Ant Users List
>Subject: Re: Output of SQL-task
>
>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
>
>

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


Mime
View raw message