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:[EMAIL PROTECTED] >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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
