(RADIATOR) concatenation within select statement

[Hugh Irvine]

Hello calvin -

It is not clear to me exactly what you are trying to do - could you give me a 
more detailed description of your requirements please?

thanks

Hugh


On Thu, 9 May 2002 11:15, calvin kwok wrote:
> hi,
>
> In normal SQL statement, you can concatenate variable
> with  "&" sign, can you do this in AuthSelect
> statement?
> eg.
> if you are going to separate the realm and username in
> the db table and you strip the realm from the username
> and authenticate the name and realm part separately
> using the following statement,
> AuthSelect select USERNAME & @%R',PASSWORD,Realm from
> SUBSCRIBERS where '%n'=USERNAME & '@%R' and Realm='%R'
>
>
> if you cant do this, how can you store the realm
> variable after UsernameRewrite so that it can be
> retrieve later to check against the database?
>
> regards
> calvin
>
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Mother's Day is May 12th!
> http://shopping.yahoo.com
> ===
> 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.