SQL SELECT statement

[Charly]

Thank you Alan. Do you know if i can use another way to do it ?

Le 18/05/2020 à 15:00, Alan DeKok a écrit :
> On May 18, 2020, at 4:42 AM, Charly <netflow at geosciences.ensmp.fr> wrote:
>> 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.
>    Yes.  The internal APIs have no way of returning multiple values from an SQL SELECT statement.
>
>    This will be fixed in v4.
>
>    Alan DeKok.
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html