Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <jmeter-user@jakarta.apache.org>
Received-SPF: neutral (nike.apache.org: 216.139.236.26 is neither permitted
 nor denied by domain of mattkingaby@googlemail.com)
Date: Fri, 4 Mar 2011 07:23:09 -0800 (PST)
From: Reg King <mattkingaby@googlemail.com>
To: jmeter-user@jakarta.apache.org
Message-ID: <1299252189427-3409634.post@n5.nabble.com>
Subject: using SQL select results as a Variable
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi All,
I am new to jmeter, and new to development so i am sorry if this is a simpl=
e
question, i am unfortunatly finding it a little hard to sus out.

I would like to use the results of a MySQL statement as a variable to later
call in a HTTP post Request. The basic test is this: As part of the test
plan i need to delete a record from the DB (via the HTTP Request), however
the delete function uses the table ID as a hidden value. Each time a record
is created the ID changes in the DB, so I cannot use a constant value and
need to select the record ID value and use it as a variable for the HTTP
Request to call.

SQL =3D select ID from orderdetails where userno =3D 'AA044' and and accno =
=3D
99999999;

I have set up a JDBC request to get this from the DB which is returning =E2=
=80=98ID
XXXXXX=E2=80=99. This is where i am getting a little lost. I have set up a =
regex
after this but am unable to sus out what the settings should be, or what
else i need to do to.
Would it be possible for someone to give me a really basic ABC step guide t=
o
how i can get this to work?
Thank you very much for your time with this, after 3 hours of staring at
jmeter im getting a little frazzled


--
View this message in context: http://jmeter.512774.n5.nabble.com/using-SQL-=
select-results-as-a-Variable-tp3409634p3409634.html
Sent from the JMeter - User mailing list archive at Nabble.com.

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