Derek, Regarding the issue #2, substitution, have you tried using __evalVar instead of __V? "V" function evaluates a variable name and you need "evalVar" to actually get the value [integer in your case] stored in that variable.
As for the first issue, double check the values using Debug Sampler (before and after your JDBC sampler) and also try if extracting the value from response works for you. Why do you use ${count_1}, i.e. what's stored in ${count}? Depending on JMeter version you're using, did you set "Parameter Types" in your JDBC sampler? Nermin -----Original Message----- From: derekmw [mailto:derekwrobelt...@gmail.com] Sent: 26. srpanj 2011 20:21 To: jmeter-user@jakarta.apache.org Subject: Issues with JDBC Request and variables Hi, I apologize if this has been answered as I am not sure what to search for. I believe this is a unique situation. I have two problems: 1. I have a JDBC request which does a VERY simple "select statement" with the following sql: select count(member_id) from member This is then stored in a variable named count. I know what the count should be (should be 312), but the value count_1 gets is 40077. What is even more troubling is at some point, it started working and getting the correct count. Any idea what is going on? 2. In a seperate JDBC request, I retrieve a list of members: select member_id from members This is stored in a variable named members. Then I created a THIRD JDBC request to query and grab a random member: select * from members where member_id = ? In "Parameter values", I put in ${__V(member_${__Random(1,10)})} (note I put 10, not $count because I can't even get it to work correctly with a hard coded number). I see that this gets parsed correctly, but the error I get is: org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: "member_7" So it's not substituting the member_7 variable's value. Instead it's just passing the string. What am I doing wrong here? -- View this message in context: http://jmeter.512774.n5.nabble.com/Issues-with-JDBC-Request-and-variables-tp 4635807p4635807.html Sent from the JMeter - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org