ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Weber <jeremy.we...@activevos.com>
Subject Re: How to assign a result of sqltask to variable
Date Tue, 06 May 2008 21:51:23 GMT
You cant directly, but you might be able to use the output attribute to 
store the user_id in a file and then read the contents of the file into 
a property with LoadFile.  Its worth a shot, but I wonder if you will 
get more information in the file than just user_id.

I am Who i am wrote:
> Hi All
>
> How to assign a result of sqltask to variable
>
> E.g.
>
> Lets say i have this in my build.xml
>
> <sql
>     driver="oracle.jdbc.driver.OracleDrive"
>     url="jdbc:database-url"
>
>     userid="sa"
>     password="pass"
>     >
> SELECT user_id FROM user where user_name=${user.name};
> </sql>
>
> in this how do i assign user_id now to any variable,?
>
> Please help
>
>   


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message