I don't believe the sql task is meant for retrieving records so much as running inserts and updates. You can redirect the output to a file, which may be the only way you can retrieve these values. d.
-----Original Message----- From: ALIA, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 10:59 AM To: [EMAIL PROTECTED] Subject: Multiple values in sql task with Ant Hi. I've searched through archives but I wasn't able to find correct answer to this question... I'm trying to get multiple fields values from a sql task into several variables. For example, <sql ...> SELECT field1, field2, field3 FROM table WHERE condition </sql> And then manipulate properties like ${field1}, ${field2}... I can also grab these values from a java task, but the question subsists : how do I put these values into variables ? Thanks a lot for your help David --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
