Hi Leon,<br><br>Thanks for your help.<br><br>I have changed it according to your comment but I am still getting the looping error.<br><br>Would you please take a look see what else I did wrong?<br><br>Also, sip_user is an integer field, so I can't really use ''. Is there anyway to get around that?<br>
<br><br><configuration name="xml_odbc.conf" description="XML ODBC Configuration"><br><br> <settings><br> <param name="binding" value="directory"/><br> <param name="odbc-dsn" value="class5_odbc:root:abcd"/><br>
<param name="debug" value="true"/><br> <param name="keep-files-around" value="true"/><br> </settings><br><br> <templates><br><br> <template name="default"><br>
<document type="freeswitch/xml"><br> <section name="directory"><br> <xml-odbc-do name="query" on-empty-result-break-to="not-found" value="SELECT enabled, sip_password FROM agent WHERE sip_user = ${user} and enabled='t'"/><br>
<domain name="${domain}"><br> <user id="${user}"><br> <params><br> <xml-odbc-do name="query" value="SELECT sip_password FROM agent WHERE sip_user = ${user}"><br>
<param name="password" value="${sip_password}"/><br> </xml-odbc-do><br> </params><br> </user><br> </domain><br>
<br><br> </section><br> </document><br> </template><br><br><br> <template><br><br> <document type="freeswitch/xml"><br> <section name="result"><br>
<result status="not found"/><br> </section><br> </document><br> </template><br> </templates><br><br></configuration><br>