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

On Mar 3, 2015, at 3:14 PM, James Wood <james.wood@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.