(RADIATOR) Multiple Rows in AuthBySQL

[Hugh Irvine]

Hello Rickard -

The standard AuthBy SQL clause will only process the first row returned 
by the query, so in your case I would run a query that included a 
reference for the service required. You could chain together two AuthBy 
SQL clauses to first find the service description and then the second 
to find the corresponding user description.

Alternatively, you could use a Hook, or you could write a custom 
version of AuthSQL.pm that does what you require. You will find some 
example hooks in the file "goodies/hooks.txt", and you will find a 
discussion on custom AuthBy modules in section 17 of the Radiator 3.5 
reference manual ("doc/ref.html").

regards

Hugh


On Thursday, Feb 6, 2003, at 04:20 Australia/Melbourne, Rickard Ekeroth 
wrote:

>
> Is there any way to have the Radiator evaluate multiple rows and 
> select the
> one that matches from the result of an AuthSelect in an AuthBySQL 
> clause?
>
> I want to be able to have multiple different services for the same 
> username
> and it would be VERY nice if Radiator could select the row with the 
> matching
> check attributes for me.
>
> Regards,
>
> Rickard Ekeroth @ SPIDERNET
> Programmer/Analyst
> rickard at spidernet.net
>
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.