Return-Path: 
 <user-return-49989-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 44244 invoked from network); 2 May 2005 18:51:57 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 2 May 2005 18:51:57 -0000
Received: (qmail 91686 invoked by uid 500); 2 May 2005 18:53:16 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 91633 invoked by uid 500); 2 May 2005 18:53:15 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Subscribe: <mailto:user-subscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 91617 invoked by uid 99); 2 May 2005 18:53:15 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from mta3.swift.com (HELO besec550.swift.com) (194.78.35.133)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 02 May 2005 11:53:15 -0700
Received: from bemigl01.swift.com (bemigl01 [172.24.34.41])
	by besec550.swift.com (Switch-3.1.6/Switch-3.1.6) with ESMTP id
 j42Ikdbt024578
	for <user@ant.apache.org>; Mon, 2 May 2005 18:46:40 GMT
Date: Mon, 02 May 2005 20:51:38 +0200
From: RADEMAKERS Tanguy <Tanguy.RADEMAKERS@swift.com>
Subject: RE: Output of SQL-task
To: Ant Users List <user@ant.apache.org>
Message-id: <A104E3221121294998E6441F8F291A4DFEACA0@BE-EXCHANGE-02.swift.corp>
MIME-version: 1.0
X-MIMEOLE: Produced By Microsoft Exchange V6.0.6556.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Thread-Topic: Output of SQL-task
Thread-Index: AcVPCzenppfMcAjjQ4OM7zYMD5WOsAAPJS/Q
Content-class: urn:content-classes:message
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
X-OriginalArrivalTime: 02 May 2005 18:51:38.0771 (UTC)
 FILETIME=[F8F07E30:01C54F47]
X-MASF: 0.00%
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

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