Hello Toomas -
If your database supports stored procedures, you could use that. Otherwise you can set up a Handler for this specific case, and use multiple AcctSQLQueries in an AuthBy SQL clause. regards Hugh On Wed, 13 Mar 2002 23:43, Toomas Kärner wrote: > Hi, > > My problem is that I cant find a way to execute two SQL querys because of > single accounting-on or accounting-off packet. Wher the box goes down or > comes up everything works with session database (it get's cleared) but I > want to have that message also in the user accounting log table. We are > planning to start counting time and then if the box goes down and I have > only start records then, I can't count anything because that message is not > in the log. As I tried and as it was writen in here ";" between the querys > doesn't help. Only way to do it is in some sord of PreClientHook but I'm > afraid of the impact to preformance (because this is executed on every > incomeing packet - the longer it is .... the slower it is ....). > > > Rgds. > > Toomas Kärner > > > === > Archive at http://www.open.com.au/archives/radiator/ > Announcements on [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.