You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Simon De Uvarow <sd...@gmail.com> on 2006/01/30 12:37:17 UTC
Re: ezmlm response
hi, sorry for dis spellings, the English is not my native language.
ok, now the doubt. I want to parametrize the SQL constraint of the
JDBCSamplers. I try the following string but it does not work.
"select * from factura f where f.NumFactu =3D %{nf} "
where nf is a variable. I want to know if now is possible do what i want.
thanks,Simon
Re: ezmlm response
Posted by Simon De Uvarow <sd...@gmail.com>.
yes .. sorry .... the mail server translated the sentence ...
i put the following sentence in the JDBC Request ...
" select * from factura f where f.NumFactu = '%{nf}' "
then, i run the script and the results tree (where we can see the petition
and de response) shows:
"select * from factura f where f.NumFactu = '%{nf}' "
the variables didn`t made translated. ... i thinks it should show
"select * from factura f, detallefactura d where f.NumFactu = '5' "
where '5' is the value in the variable.
there is my problemm ...
thanks, Simon
2006/1/30, sebb <se...@gmail.com>:
>
> That should probably be:
>
> "select * from factura f where f.NumFactu = ${nf} "
>
> or
>
> "select * from factura f where f.NumFactu = '${nf}' "
>
> if NumFactu is a string.
>
> Variables are referenced as ${varname} - not %{varname}
>
>
> Remember to set "Query Only" to true.
>
>
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Request
>
> S.
> On 30/01/06, Simon De Uvarow <sd...@gmail.com> wrote:
> > hi, sorry for dis spellings, the English is not my native language.
> >
> > ok, now the doubt. I want to parametrize the SQL constraint of the
> > JDBCSamplers. I try the following string but it does not work.
> >
> > "select * from factura f where f.NumFactu =3D %{nf} "
> >
> > where nf is a variable. I want to know if now is possible do what i
> want.
> > thanks,Simon
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
Re: ezmlm response
Posted by sebb <se...@gmail.com>.
That should probably be:
"select * from factura f where f.NumFactu = ${nf} "
or
"select * from factura f where f.NumFactu = '${nf}' "
if NumFactu is a string.
Variables are referenced as ${varname} - not %{varname}
Remember to set "Query Only" to true.
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Request
S.
On 30/01/06, Simon De Uvarow <sd...@gmail.com> wrote:
> hi, sorry for dis spellings, the English is not my native language.
>
> ok, now the doubt. I want to parametrize the SQL constraint of the
> JDBCSamplers. I try the following string but it does not work.
>
> "select * from factura f where f.NumFactu =3D %{nf} "
>
> where nf is a variable. I want to know if now is possible do what i want.
> thanks,Simon
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org