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

[James Wood]

Thanks, that sounds like a reasonable plan until something is (hopefully) introduced.

So if I had this simple query:

SELECT CONCAT(`Session-Timeout`, '#', `Idle-Timeout`, '#', `Filter-Id`) FROM settings...

That returns:

86400#3600#Test

Where 86400 is the Session Timeout, 3600 is the Idle-Timeout and Test is the Filter-Id.

How can I split this in the FreeRadius conf in to the three separate variables using # as the delimiter?

Thanks

James