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