On 18/01/2009, yaroslav1 <[email protected]> wrote: > > the idea is like this: > > 1. do a JDBC request like: > SELECT ("field=" + field) as field FROM table; > > As result in ResponseData you will have: > > field=<data> > > 2. use "Post Beanshell" sample in the JDBC to extract data by template: > "field=(.+)" > > If you have more then 1 field - then use for all fields the extract template > as "field1=(.+\r)", > "field2=(.+\r)", and etc > \r - means that the data are "tab" delimited.
\r means carriage return, not tab, which is \t > For the last field use a template like - "fieldN=(.+)" > > I think it will help you. > Yaroslav > > > > > EvilPeanut wrote: > > > > Hi yaroslav1 > > > > I would be very interested in more detail. Do you by chance have an > > example of this? I'm trying to get this working within the next few hours, > > so I'm pretty desperate to get this done ASAP. Sorry if it seems like I'm > > just grabbing at straws. > > > > Thanks in Advance > > > > > > yaroslav1 wrote: > >> > >> Hi Paul-the-hat, > >> > >> You can use some tricky technique to get your goal. You need to update > >> SELECT statement to use your defined column names with printing each of > >> them in new line. Once you reach this result you can just simply use > >> post-regular-expression-extractor to create variables for them. > >> If you need more detail, let me know. > >> > >> Happy New Years everybody! > >> > >> > >> > > > > > > > -- > View this message in context: > http://www.nabble.com/JDBC-Request%3A-Select-returning-values-to-variables-tp20931986p21524862.html > > Sent from the JMeter - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > 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]
