<html><head></head><body><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div>I have decided to do Hunting DIY. I needed some help with the cfg script part and using a database dip. </div><div><br></div><div>Say I do the db dip </div><div><br></div><div><span><pre class="ydpfea46ad6programlisting" style="background-color: rgb(252, 255, 252); border: 1px solid rgb(153, 204, 204); color: rgb(0, 0, 0); padding-left: 15pt; border-radius: 2.5px; font-size: 15px;">sql_xquery("ca", "call usp_GetHuntBranches( '$rU', '$rd');", "ra");</pre></span></div><div>that will return the uri/q pairs and I will add using append_branch dynamically. </div><div><br></div><div>How do I do the looping in the script?</div><div><br></div><div>I have 2 ways to deliver the list via the sp.</div><div><ol><li>Rows with uri and q values. easiest </li><li>Single row with variable paired fields like say ur1,q1,ur2,q2 etc etc </li></ol>Questions :</div><div><ol><li>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?</li><li>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 |.</li><li>Or is there a document that explains the various generic functions I can use the cfg script area.</li></ol>KD <br></div></div></div></body></html>