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: 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...

/t 

>-----Original Message-----
>From: Steve Loughran [mailto:stevel@apache.org] 
>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.
>
>-steve
>
>---------------------------------------------------------------------
>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