Thanks for the response. I was able to fix the problem using storeProperty below
From: [EMAIL PROTECTED]: [email protected]; [EMAIL PROTECTED]: Fri, 2 May 2008 07:12:55 -0500Subject: RE: [Webtest] Using ant sql... 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] 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 NigamSent: Friday, May 02, 2008 1:33 AMTo: [EMAIL PROTECTED]: [Webtest] Using ant sql... Hi, Somewhere inside the target, I have following statements: <setInputField description="email address" name="temp.email" value="[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? _________________________________________________________________ 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
