Re: [SR-Users] avp_db_query

Ok, thanks El 18/09/2016 a las 11:16, Federico Cabiddu escribió: Hi, you may use sqlops module for executing queries from routing script: http://www.kamailio.org/docs/modules/4.0.x/modules/sqlops.html Cheers, Federico On 17 Sep 2016 13:38, "Angel Elena" > wrote:

Re: [SR-Users] avp_db_query

Hi, you may use sqlops module for executing queries from routing script: http://www.kamailio.org/docs/modules/4.0.x/modules/sqlops.html Cheers, Federico On 17 Sep 2016 13:38, "Angel Elena" wrote: > Hi, good moorning. > > I have a Kamailio 4.0 with avp module working. > > Now, I need write some

Re: [SR-Users] avp_db_query => affected rows

Hello, Thank you for the clarification. David On 13-07-15 09:53 AM, Alex Balashov wrote: On 07/15/2013 09:52 AM, David K wrote: Are you saying that avp_db_query is obsolete? It's not obsolete in the sense of deprecated, it's just not the most flexible, modern way to access SQL databases.

Re: [SR-Users] avp_db_query => affected rows

Hello, Thank you for the clarification. David On 13-07-15 09:53 AM, Alex Balashov wrote: On 07/15/2013 09:52 AM, David K wrote: Are you saying that avp_db_query is obsolete? It's not obsolete in the sense of deprecated, it's just not the most flexible, modern way to access SQL databases.

Re: [SR-Users] avp_db_query => affected rows

On 07/15/2013 09:52 AM, David K wrote: Are you saying that avp_db_query is obsolete? It's not obsolete in the sense of deprecated, it's just not the most flexible, modern way to access SQL databases. It was the only way to do it before 'sqlops' came along. -- Alex Balashov - Principal Eva

Re: [SR-Users] avp_db_query => affected rows

Hello, Are you saying that avp_db_query is obsolete? Thanks for the clarification, David On 13-07-15 09:44 AM, Alex Balashov wrote: On 07/15/2013 09:40 AM, David K wrote: Hello, I want to run an SQL UPDATE command from my kamailio script. I am using the command 'avp_db_query'. How can I g

Re: [SR-Users] avp_db_query => affected rows

On 07/15/2013 09:40 AM, David K wrote: Hello, I want to run an SQL UPDATE command from my kamailio script. I am using the command 'avp_db_query'. How can I get the number of affected rows after the UPDATE runs? This is a very legacy, obsolete approach to custom SQL query interactions. What

Re: [SR-Users] avp_db_query - closing the connection

Hello, On 2/19/12 5:16 AM, graham wrote: Hi all, I have been using more and more avps for per-call queries populated by custom mysql queries. I would like to know how the connections of mysql queries are being closed. I tried to locate a command to do such, but unable to locate. Do they cl

Re: [SR-Users] avp_db_query() question

please keep the mailing list cc-ed all the time. Thanks, Daniel On 1/20/11 1:49 PM, ?? wrote: many thanks I've fixed the problem. Using $(avp(s:name)) instead of $avp(s:name) Your solution is OK too. At 2011-01-20 18:10:40??"Daniel-Constantin Mi

Re: [SR-Users] avp_db_query() question

Hello, maybe is better to use sqlops module, it more suitable for queries with many records in result. http://kamailio.org/docs/modules/stable/modules_k/sqlops.html Cheers, Daniel On 1/19/11 2:58 PM, Klaus Darilion wrote: looks fine. try to increase debug level - then you should see the quer

Re: [SR-Users] avp_db_query() question

looks fine. try to increase debug level - then you should see the query and the results in syslog regards klaus Am 18.01.2011 12:07, schrieb ??: Hello |avp_db_query(query[,dest]) can get a database query and store the results in the avps.| |But what if the results ret

Re: [SR-Users] avp_db_query returning wrong data

Hello, On 12/20/10 4:33 PM, Jijo wrote: Hi All, I applied the following patch which fixed the issue. http://sip-router.org/tracker/index.php?do=details&task_id=97 Are we going to merge this patch to Kamailio 3.1.x? the patch wa

Re: [SR-Users] avp_db_query returning wrong data

Hi All, I applied the following patch which fixed the issue. http://sip-router.org/tracker/index.php?do=details&task_id=97 Are we going to merge this patch to Kamailio 3.1.x? Thanks Jijo On Wed, Nov 24, 2010 at 9:35 AM, Jijo wrote: > I'm using kamailio 3.1.0, so this is already in place.. Is

Re: [SR-Users] avp_db_query returning wrong data

I'm using kamailio 3.1.0, so this is already in place.. Is there any other change happened after 3.1.0 release? On Wed, Nov 24, 2010 at 3:41 AM, Daniel-Constantin Mierla wrote: > > > On 11/24/10 12:59 AM, Alex Balashov wrote: > >> On 11/23/2010 06:41 PM, Jijo wrote: >> >> Yes it work with many

Re: [SR-Users] avp_db_query returning wrong data

On 11/24/10 12:59 AM, Alex Balashov wrote: On 11/23/2010 06:41 PM, Jijo wrote: Yes it work with many UDP children. There were some concurrency issues with the Postgres module a while back, discovered after the 3.1.0 release. I remember something about it because we are extremely heavy us

Re: [SR-Users] avp_db_query returning wrong data

On 11/23/2010 06:41 PM, Jijo wrote: Yes it work with many UDP children. There were some concurrency issues with the Postgres module a while back, discovered after the 3.1.0 release. I remember something about it because we are extremely heavy users of the Postgres module as well. Unfortuna

Re: [SR-Users] avp_db_query returning wrong data

Does it work with many UDP children? -- 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/ On Nov 23, 2010, at 6:13 PM, Jijo wrote: Hi All, While doing 5 REG