I have decided to do Hunting DIY. I needed some help with the cfg script part and using a database dip. Say I do the db dip sql_xquery("ca", "call usp_GetHuntBranches( '$rU', '$rd');", "ra");that will return the uri/q pairs and I will add using append_branch dynamically. How do I do the looping in the script? I have 2 ways to deliver the list via the sp. - Rows with uri and q values. easiest - Single row with variable paired fields like say ur1,q1,ur2,q2 etc etc Questions : - Can the script handle sql_xquery with multiple rows. If so, can I get a code snippet or example that show me how to iterate through. Is there a "while" loop capability in the script? - Is there a "substring" or "split" function in the script that could allow me to get the data as a single text with uri and q separated by a \ or |. - Or is there a document that explains the various generic functions I can use the cfg script area. KD
1. Here's the documentation for while loop: http://www.kamailio.org/wiki/cookbooks/devel/core#while
2. Here are some string helper functions: http://www.kamailio.org/wiki/cookbooks/devel/transformations#ssubstr_offset_... http://www.kamailio.org/wiki/cookbooks/devel/transformations#sselect_index_s...
3. You can browse documentation here: http://www.kamailio.org/wiki/#cookbooks
Regards, Ovidiu Sas
On Wed, May 16, 2018 at 5:59 PM, KamDev Essa kamdevessa@yahoo.com wrote:
I have decided to do Hunting DIY. I needed some help with the cfg script part and using a database dip.
Say I do the db dip
sql_xquery("ca", "call usp_GetHuntBranches( '$rU', '$rd');", "ra");
that will return the uri/q pairs and I will add using append_branch dynamically.
How do I do the looping in the script?
I have 2 ways to deliver the list via the sp.
Rows with uri and q values. easiest Single row with variable paired fields like say ur1,q1,ur2,q2 etc etc
Questions :
Can the script handle sql_xquery with multiple rows. If so, can I get a code snippet or example that show me how to iterate through. Is there a "while" loop capability in the script? Is there a "substring" or "split" function in the script that could allow me to get the data as a single text with uri and q separated by a \ or |. Or is there a document that explains the various generic functions I can use the cfg script area.
KD
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Awesome. Thanks KD On Thursday, May 17, 2018, 11:38:14 AM EDT, Ovidiu Sas osas@voipembedded.com wrote:
1. Here's the documentation for while loop: http://www.kamailio.org/wiki/cookbooks/devel/core#while
2. Here are some string helper functions: http://www.kamailio.org/wiki/cookbooks/devel/transformations#ssubstr_offset_... http://www.kamailio.org/wiki/cookbooks/devel/transformations#sselect_index_s...
3. You can browse documentation here: http://www.kamailio.org/wiki/#cookbooks
Regards, Ovidiu Sas
On Wed, May 16, 2018 at 5:59 PM, KamDev Essa kamdevessa@yahoo.com wrote:
I have decided to do Hunting DIY. I needed some help with the cfg script part and using a database dip.
Say I do the db dip
sql_xquery("ca", "call usp_GetHuntBranches( '$rU', '$rd');", "ra");
that will return the uri/q pairs and I will add using append_branch dynamically.
How do I do the looping in the script?
I have 2 ways to deliver the list via the sp.
Rows with uri and q values. easiest Single row with variable paired fields like say ur1,q1,ur2,q2 etc etc
Questions :
Can the script handle sql_xquery with multiple rows. If so, can I get a code snippet or example that show me how to iterate through. Is there a "while" loop capability in the script? Is there a "substring" or "split" function in the script that could allow me to get the data as a single text with uri and q separated by a \ or |. Or is there a document that explains the various generic functions I can use the cfg script area.
KD
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
KamDev Essa -
Ovidiu Sas