hello,<br>I tried following in route script.<br><br>route{<br> <br> if (is_method("INVITET"))<br> {<br> avp_db_query("select count from load_count where dest='1'","$avp(i:1)");<br>
# avp_db_query("select count from load_count where dest='2'","$avp(i:2)");<br><br> if(avp_check("$avp(i:1)", "eq/1/i"))<br> {<br> avp_db_query("update load_count set count='0' where dest='1';");<br>
<br> forward("<a href="http://172.29.9.140:5060">172.29.9.140:5060</a>");<br> #forward();<br> exit();<br> }<br> else<br> { avp_db_query("update load_count set count='1' where dest='1';");<br>
<br> # forward();<br> forward("<a href="http://172.29.9.136:5060">172.29.9.136:5060</a>");<br> exit;<br> }<br> }<br> } <br><br>only else part is working. All calls are forwarded to 136 only.<br>
I think it is not modifying database or its not persistent.<br>Please tell if that update query is correct and anything else i have to do to make db persistent?<br>thank you<br>