[SR-Users] cfg script 101

[KamDev Essa]

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     
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180516/9a4ddcfb/attachment.html>