[Kamailio-Users] sqlops problem

[Daniel-Constantin Mierla]

Hello,

On 03/03/2009 12:58 PM, BERGANZ François wrote:
>
> I follow the module instructions and I do :
>
> sql_query("ca", "select server from servers where etat_ping=’oui’ & 
> etat_asterisk=’oui’", "nb_srv");
>
> $var(i) = 0;
>
> $var(s)=$dbr(nb_srv=>[server,$var(i)]); ### line 166
>

the indexes to access the value must be integers or PV holding integers, 
like:
$var(s)=$dbr(nb_srv=>[0,$var(i)]);

Cheers,
Daniel

> I have that error:
>
> ERROR:sqlops:sql_parse_index: bad number <server>
>
> ERROR:sqlops:pv_parse_dbr_name: invalid index in [[server,$var(i)]]
>
> ERROR:core:pv_parse_spec: pvar "dbr" has an invalid name param 
> [nb_srv=>[server,$var(i)]]
>
> ERROR:core:pv_parse_spec: wrong char [)/41] in 
> [$dbr(nb_srv=>[server,$var(i)])] at [29 (5)]
>
> CRITICAL:core:yyerror: parse error in config file, line 166, column 
> 110-140: unknown script variable
>
> Anyone know why?
>
> Thank you
>
> Cordialement,
>
> BERGANZ François
>
> P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Kamailio (OpenSER) - Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users

-- 
Daniel-Constantin Mierla
http://www.asipto.com