ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "RADEMAKERS Tanguy" <>
Subject RE: Using SQL query result as a property, how?
Date Thu, 08 Feb 2007 16:41:05 GMT
can't find it in my mails, but there's a hack for this. Depending on
your database, you should be able to tell it *not* to write that info at
the end (something like "set nocount" on oracle). Search the archives,
it's come up before...


>-----Original Message-----
>From: Steve Loughran [] 
>Sent: Thursday, February 08, 2007 5:01 PM
>To: Ant Users List
>Subject: Re: Using SQL query result as a property, how?
>Hans Schwaebli wrote:
>> I have a SQL query which returns one result like 388291. I 
>want to use that result as a property.
>>   How can this be done in Ant?
>>   In a script language like Python (haha) this is no 
>problem. But how to solve it with Ant?
>>   If I use the SQL-Task I only can write the result to disk. 
>It looks like this:
>>    78721
>>    0 rows affected
>>   If I could return the result in a result property, it 
>would be okay, if "0 rows affected" would not be part of it.
>>   Any solution?
>not yet. In theory we could pump the output through a filter chain, or 
>just add a feature to <sql> to save the result into a 
>property.  This is 
>just something nobody has implemented yet.
>To unsubscribe, e-mail:
>For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message