SQL SELECT statement

18 May 2020

      Hello,

I would like to update Cisco-AVPair attribute using a SQL request :

                 update reply {
                         Cisco-AVPair += "%{sql:SELECT value FROM 
radreply WHERE username = '%{User-Name}' AND attribute = 'Cisco-AVPair' 
ORDER BY id}"
                 }

But only the first row is returned.

Charlye