Two sql queries in counter module

2006-11-02 Thread Bishal 

Hello all

 Is it possible to make two queries in sql counter module? like


sqlcounter noresetcounter {
driver = rlm_sqlcounter
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query1=SELECT activedate from radacct where
username='%{%k}'
query = SELECT SUM(AcctSessionTime) FROM
radacct WHERE UserName='%{%k}' AND ActiveDate='$query1'
}

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Two sql queries in counter module

2006-11-02 Thread Alan DeKok 
Bishal [EMAIL PROTECTED] wrote:
  Is it possible to make two queries in sql counter module? like

  No.

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html