[Kamailio-Users] sqlops problem

[BERGANZ François]

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

 

 

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.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20090303/4e48d6e9/attachment.htm