<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>On a similar note, If I wanted to use the first result in the second update request, how can I go about that?</div><div><br></div><div>I've tried the following, but I get a blank value for SQL-Location-Id</div><div><br></div><div><br></div><div><div><div><div>update request {</div><div> SQL-Location := "%{sql: SELECT xxx}"</div><div> }</div></div></div><br></div><div><div><div><div>update request {</div><div> SQL-Location-Id := "%{sql: SELECT * where XXX = '%{SQL-Location-Id}' }"</div><div>}</div></div></div></div><div><br></div><div><br></div><div>Is this possible?</div><div><br></div><div><br></div><br><div><div>On 26 Jul 2012, at 12:41, Jenny Blunt wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div>How do I go about comparing two attributes from an update request?</div><div><br></div><div>I have the following in my default conf. file:</div><div><br></div><div><div>update request {</div><div> SQL-Location := "%{sql: SELECT xxx}"</div><div> }</div><div> </div><div>update request {</div><div> SQL-Location-Id := "%{sql: SELECT yyy }"</div><div>}</div><div><br></div><div>if (SQL-Location != SQL-Location-Id ) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> reject</div><div>}</div></div><div><br></div><div>And my debug log shows:</div><div><br></div><div>Info: Failed parsing "SQL-Location-Id": Unknown value SQL-Location-Id for attribute SQL-Location</div><div><br></div><div><br></div></div>
-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></blockquote></div><br></body></html>