SQL SELECT statement

[Alan DeKok]

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.