So what you are saying I should do something like Thread Group JDBC Reuqest select col1 || ',' || col2 from table -----Reg Exp Ref Name = inputVar Refular Expresssion = (.*),(.*) Template = $1$$2$ Match No. = -1 Default Value = 0,0 FOR EACH CONTROLLER INPUT VAR = InputVar OUTPUTVAR = OutputVar
And I am lost again. I dont see how to get the data once I am in the foreach. Do I use user parameters? How do I get those 2 columns?? Thank you On Wed, Jul 16, 2008 at 5:20 PM, sebb <[EMAIL PROTECTED]> wrote: > On 16/07/2008, Jose Castro <[EMAIL PROTECTED]> wrote: >> I want to call a sql query and then have the data populate a soap request >> >> I would expect I could do something like >> >> THREAD GROUP >> JDBC_REQUEST (select col1, col2 from table) >> FOREACH CONTROLLER >> ---SOAP REQUEST USING ${col1} and ${col2) >> >> >> But no luck. >> > > The SQL Sampler does not save results in variables. > > You can extract the values from the response data using the Regex > Post-Processor. > >> Could someone please provide the correct format to do this. >> >> Thank you >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]