Hello,

I guess you are using sql_xquery? The sql_free_result will only free a native sql result in script, not the xavp.

Cheers,

Henning

--

Henning Westerholt – https://skalatan.de/blog/

Kamailio services – https://gilawa.com

From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of Duarte Rocha
Sent: Wednesday, June 24, 2020 5:59 PM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: [SR-Users] Sql_result_free() not cleaning properly

Greetings, 

I'm trying to clean a SQL result using "sql_result_free()" but i'm not having success. 

Can you please verify if i'm doing anything wrong here?

This is my code : 

            xerr("Pre clean [0] = Iterator 0 = $xavp(Cli_PICKER_Default_Search_Result[0]=>Code)");

            sql_result_free("Cli_PICKER_Default_Search_Result");    

            xerr("Pos clean [0] = Iterator 0 = $xavp(Cli_PICKER_Default_Search_Result[0]=>Code)");

The result is the following : 

                ERROR: <script>:Pre clean [0] = Iterator 0 = 111111111111

                ERROR: <script>:Pos clean [0] = Iterator 0 = 111111111111

Am i using sql_result_free correctly or doing something wrong?

Best Regards,