Based on the code you included ${temp.email} is not defined. name="temp.email"
is the name of the textfield you are setting not the name of a property. If
you want to insert the value [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> into
both a textfield and the sql then save it as a property like
<storeProperty name="myProperty" value="[EMAIL PROTECTED]"/>
<setInputField name="temp.email" value="${myProperty}"/>
and then you can replace ${temp.email} in your sql code with the name of the
property
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Deepa Nigam
Sent: Friday, May 02, 2008 1:33 AM
To: [email protected]
Subject: [Webtest] Using ant sql...
Hi,
Somewhere inside the target, I have following statements:
<setInputField description="email address"
name="temp.email"
value="[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" />
I need to pass this value to insert statment as below:
<sql
driver="oracle.jdbc.driver.OracleDriver"
url="${url}"
userid="apps"
password="password">
insert into user_t values
('121206','2854637','${temp.email}',4,5,6,7,8,9,'01-DEC-08','E',12)
</sql>
In this case ${temp.email} is getting inserted as string. Can somebody please
point to me what is the problem in the above code.
Also, Can we used <preparedStatement> inside ant SQL
Thanks so much,
Deepa
________________________________
Back to work after baby- how do you know when you're
ready?<http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A>
