[OpenSIPS-Users] Can I use 'UPDATE' in avp_db_query ?

[Podrigal, Aron]

Try removing the second argument *"$avp(CallMaxDuration)"* from
avp_db_query() Because the database backend does not return any results.

On Tue, Nov 3, 2015 at 8:50 AM, Rodrigo Pimenta Carvalho <pimenta at inatel.br>
wrote:

> Dear OpenSIPS-users,
>
>
> In the OpenSIPS database I have created some new tables, for my project. I
> can read from such tables successfully.  For example, the instruction
>
>
>  *avp_db_query("select Value from GeneralConfigurations where Attribute =
> 'CallMaxDuration'", "$avp(CallMaxDuration)");*
>
>
> run and works very well. It put the right value in the apv!
>
>
> However, when the following instruction is executed, it doesn't take any
> effect in the database:
>
>
> * avp_db_query("update GeneralConfigurations set Value = 'yes' where
> Attribute = 'Exists_Intercom_Call'", "$avp(UpdateResult)");*
>
>
> The log says:
>
>
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> Nov  3 11:32:52 [29114] DBG:avpops:ops_dbquery_avps: query [update
> GeneralConfigurations set Value = 'yes' where Attribute =
> 'Exists_Intercom_Call']
> Nov  3 11:32:52 [29114] DBG:avpops:db_query_avp: no result after query
> Nov  3 11:32:52 [29114] DBG:avpops:db_close_query: close avp query
> Nov  3 11:32:52 [29114] ERROR:db_sqlite:db_sqlite_free_result: invalid
> parameter value
>
>
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>
> But the query UPDATE is correct, because I have already tested it directly
> in the database.
>
>
> So, am I doing something wrong? What exactly does mean that error "invalid
> parameter value" in this case? Can I use UPDATE in an avp_db_query?
>
>
> Any hint will be very helpful!
>
>
> Best regards.
>
>
>
>
>
>
>
>
> RODRIGO PIMENTA CARVALHO
> Inatel Competence Center
> Software
> Ph: +55 35 3471 9200 RAMAL 979
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 
Aron Podrigal
-
'1000001', '1110010', '1101111', '1101110'   '1010000', '1101111',
'1100100', '1110010', '1101001', '1100111', '1100001', '1101100'

P: '2b', '31', '33', '34', '37', '34', '35', '38', '36', '30', '39', '39'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20151103/30b205b8/attachment.htm>