On 22 February 2012 09:42, Michele Mase' <[email protected]> wrote: > I've tried unsuccessfully with regex extractor. > This is the response from the query1: > INVP0 > 9315554 > 9315555 > 9315556 > 9315557 > 9315558 > 9315559 > 9315560 > ... > The response field to check is the body. > If I apply the following regex/template/match no/default value > ([0-9]{7}) / $1$ / 1 / dummy > query2 is made using null as variable value, that means the query string > does not contain any data :( > What's my mistake?
Did you add a variable name on the JDBC Sampler? Try adding a Debug Sampler after the JDBC Sampler. It should show the list of values stored in variables, see: http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request > > > On Tue, Feb 21, 2012 at 6:31 PM, Britto Christy <[email protected]>wrote: > >> Get the value by using regular expression from query1 result and assign it >> variable. Now you can use this variable to query 2. >> >> >> On Tuesday, February 21, 2012, Michele Mase' <[email protected]> >> wrote: >> > I'm recording a new test plan; >> > Old style: >> > Extracting a list of value from query1 >> > Putting those data in a CVS Data Set Config, using variable1 >> > Calling query2 with variable1 >> > All works >> > New Style: >> > query1 >> > SELECT data1 FROM table1 where data1 >= (SELECT MAX (data1)-1000 FROM >> > table1) >> > the response is a long list >> > value1 >> > value2 >> > ... >> > valuen >> > I'm unable to: >> > Getting the value directly from query1 and putting them into a variable >> > variable1 >> > Utilizing variable1 for query2 >> > How can I do it? >> > Regards >> > MM' >> > >> >> -- >> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
