Hello, sql_xquery() does not store anything inside $dbr(...), it stores the result inside $xavp(...).
You have to use sql_query() to store inside $dbr(). Cheers, Daniel On 05.11.21 15:55, Benoît Panizzon wrote: > Dear List... > > kamcmd> version > kamailio 5.4.7 (x86_64/linux) > > Strange issue found. > > According to: > https://kamailio.org/docs/modules/5.4.x/modules/sqlops.html > > I should get return value 2 if no rows returned: > > $var(query) contains a query that does not match (number is not > assigned) > > if (sql_xquery("impkam", "$var(query)", "assignedtn") == 1) { > if ($avp(debug) > 1) { > xlog("L_INFO", "$cfg(route): SQL Dump Result: > $var(assignedtn) ROWS: $dbr(assignedtn=>rows) \n"); > } > do stuff with the assigned number > } else { > do stuff in case that number is not assigned > } > > Log Output: > > CHECK_ASSIGNED_TN: SQL Dump Result: 0 ROWS: 0 > > So the return value of the query was == 1 but the result contains no > rows. How can that be? > > -- > Mit freundlichen Grüssen > > -Benoît Panizzon- @ HomeOffice und normal erreichbar > -- > I m p r o W a r e A G - Leiter Commerce Kunden > ______________________________________________________ > > Zurlindenstrasse 29 Tel +41 61 826 93 00 > CH-4133 Pratteln Fax +41 61 826 93 01 > Schweiz Web http://www.imp.ch > ______________________________________________________ > > __________________________________________________________ > Kamailio - Users Mailing List - Non Commercial Discussions > * [email protected] > Important: keep the mailing list in the recipients, do not reply only to the > sender! > Edit mailing list options or unsubscribe: > * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio Advanced Training - Online Nov 08-11, 2021 (Europe Timezone) - Feb 21-24, 2022 (America Timezone) * https://www.asipto.com/sw/kamailio-advanced-training-online/ __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions * [email protected] Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
