<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks, my mistake - copied from wrong place.<div><br></div><div><br><div><div>On 27 Jul 2012, at 14:27, Alan DeKok wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Jenny Blunt wrote:<br><blockquote type="cite">On a similar note, If I wanted to use the first result in the second<br></blockquote><blockquote type="cite">update request, how can I go about that?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I've tried the following, but I get a blank value for SQL-Location-Id<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">update request {<br></blockquote><blockquote type="cite"> SQL-Location := "%{sql: SELECT xxx}"<br></blockquote><blockquote type="cite"> }<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">update request {<br></blockquote><blockquote type="cite"> SQL-Location-Id := "%{sql: SELECT * where XXX =<br></blockquote><blockquote type="cite">'%{SQL-Location-Id}' }"<br></blockquote><blockquote type="cite">}<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Is this possible?<br></blockquote><br> Of course. It works. There's no magic.<br><br> Read the debug log to see what's going on. And post the REAL<br>configuration lines you're using. Re-typing them means typos &&<br>mistakes, which makes it impossible to help you.<br><br> i.e. your second line updates SQL-Location-Id by referencing<br>SQL-Location-Id. That looks wrong.<br><br> Alan DeKok.<br>-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a><br></div></blockquote></div><br></div></body></html>