__CSVRead(file,next) always returns the empty string. This is intentional.
You need to use
__CSVRead(file,0)
__CSVRead(file,1)
...
__CSVRead(file,4)
__CSVRead(file,next)
in your test plan to be able to pick out the different columns.
Probably best to do this in a User Parameter test element, e.g.
Name Value
PASS ${__CSVRead(file,0)}
...
SID ${__CSVRead(file,4)${__CSVRead(file,next)}
Since the "next" modifier returns "", it can be combined with the last
column.
Columns don't have to be listed in numerical order, but it is important that
the "next" is processed last.
The Java Test sampler is useful for testing variables - just add the
variable(s) to the Label, and it will appear in the View Results Table (or
Tree) Listener.
S.
P.S. There was a bug in CSVRead (Bugzilla id 24076) which has only just been
fixed in CVS.
-----Original Message-----
From: Rubin, Dani [mailto:[EMAIL PROTECTED]
Sent: 27 October 2003 11:32
To: '[EMAIL PROTECTED]'
Subject: CVSRead and JDBC query
> Hi
> I am trying to iterate this SQL statement to a DB2 database
> insert into user (password, loginattempts, status, username,
> person_payworksid) values
> (${__CSVRead(C:\jakarta-jmeter-1.9.1\test_data\insert.csv,next())})
> This insert does not work and there are not errors in the error log.
> Has anyone experienced anything like this?
>
> Dani Rubin
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
