[SR-Users] SQLOps question

[Alex Balashov]

On 04/18/2010 01:21 PM, Maciej Bylica wrote:
> Hello,
>
> I am trying to use SQLOps Module in my kamailio 1.5 configuration.
>
> According to your explanations every result of sql_query should be
> freed just after using that data.
> So it means that there will be better to fetch for THE SAME data three
> times instead of just one.
> Am I right?
>
> But nevertheless I've been trying to query just one and free the
> result of the sql_query at the end of the file.
> Could sb tell me if the result of sql query executed in the main part
> of the script is remembered and could be used on failure route as
> well?

As far as I know, sqlops results are freed at the end of invocation of 
script processing of a given message, be that a request or a reply. 
They do not persist for the life of the transaction, and therefore 
cannot be reused in failure_route.

-- 
Alex Balashov - Principal
Evariste Systems LLC
1170 Peachtree Street
12th Floor, Suite 1200
Atlanta, GA 30309
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/