How to set multiple reply values via a single SQL query?

[Alan DeKok]

On Mar 3, 2015, at 3:14 PM, James Wood <james.wood at purplewifi.net> wrote:
> Is there any way to set multiple reply items via a single SQL query?

  No.  Arran and I have discussed that.  We have some ideas, but nothing final.

> At the moment, I have a table called “settings” and within that I have a
> number of columns like Session-Timeout. I am having to do multiple SQL
> queries to pull these out, even though they are in the same table, which is
> both introducing time and load on the server

  The the short term you can select 3 fields, and use SQL to concatenate them as strings.  Then, use FreeRADIUS to split the string.

  Ugly, but less load for your SQL server.

  Alan DeKok.