That makes perfect sense, I was able to send the o/p to a file now I just need to filter and load the file.
Thanks Rob. ANil -----Original Message----- From: Anderson, Rob (Global Trade) [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 11:46 AM To: Ant Users List Subject: RE: Sql task and property Anil, You may be able to accomplish what you need by using the output attribute of the <sql> task to specify an output file for the sql statement, then use the <loadfile> task to load the value contained in the output file into a property, then use the ant-contrib <if> task to test the value of the property. -Rob Anderson > -----Original Message----- > From: Jacob, Anil - MWT [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 30, 2004 11:20 AM > To: Ant Users List > Subject: Sql task and property > > > I have an sql task which checks the records in 3 tables. Is there a > way I can set a property if the value in any of the tables is > 0? > This property will be used for other tasks. > > Anil > > --------------------------------------------------------------------- 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]
