Return-Path: 
 <ant-user-return-10227-apmail-jakarta-ant-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-ant-user-archive@jakarta.apache.org
Received: (qmail 66765 invoked by uid 500); 16 Jul 2001 08:53:00 -0000
Mailing-List: contact ant-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Post: <mailto:ant-user@jakarta.apache.org>
List-Help: <mailto:ant-user-help@jakarta.apache.org>
List-Unsubscribe: <mailto:ant-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:ant-user-subscribe@jakarta.apache.org>
Reply-To: ant-user@jakarta.apache.org
Delivered-To: mailing list ant-user@jakarta.apache.org
Received: (qmail 66756 invoked from network); 16 Jul 2001 08:52:59 -0000
Message-ID: <F58968066573D4118FC600508BCF7EDA02684DDB@exchuk19.eu.ssmb.com>
From: "Samson, Lyndon [IT]" <lyndon.samson@ssmb.com>
To: "'ant-user@jakarta.apache.org'" <ant-user@jakarta.apache.org>
Subject: RE: simple yet complicated
Date: Mon, 16 Jul 2001 09:50:44 +0100
X-Mailer: Internet Mail Service (5.5.2650.21)
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

I dont think the sql task support SQL select's. ( Prb due to using
execute/executeUpdate ).

It would be nice if it did support select/executeQuery.



-----Original Message-----
From: Rigorberto Macias [mailto:rigorberto.macias@irista.com]
Sent: Friday, July 13, 2001 6:27 PM
To: ant-user@jakarta.apache.org
Subject: simple yet complicated


Hey everyone,
    One question here. Look at the following code.

<property name="buildnum" value="buildnum1.currval"/>
<sql
  driver="oracle.jdbc.driver.OracleDriver"
  url="${url}"
  userid="demo"
  password="demo"
 >

select buildnum1.nextval from dual;

 insert into build
(buildnum,branch,machinename,machineinfo,builddate,starttime,endtime,status)

 values
(${buildnum},'BRANCH','${computername}','${numberofprocessor},${processorid}
,${os},${username}',sysdate,'START
TIME','END TIME','STATUS');
</sql>


What im trying to do is set the property name of buildnum to the value
of the current build number, which is incremented and used just for
reference. every time i do this, the compiler gives me an error about
buildnum not being a valid token. I will be using the ${buildnum}
property in other parts, so that is why i want to give the current build
number value to buildnum. can anybody help me out. i would really
appreciate it. Thanks.

Rigo