Hi Andrew, On Feb 6, 7:11pm, Andrew McManus wrote: > Subject: Multiple Statements in AcctSQLStatement > Hi Group, > > We are also having problems with multiple entries for the one session being > inserted. > > I have researched the Archive, but i need to know what the following effect > would be if I tried to include a second SQL Statement in the > AcctSQLStatement and how the accounting process would handle it. > > I'm really new to Radiator, but am a long time SQL user. You can run multiple queriesd by defining several AcctSQLStatements: AcctSQLStatement delete from ACCOUNTINGTABLE where ..... AcctSQLStatement INSERT INTO ACCOUNTINGTABLE ..... > > > ie: > > delete from ACCOUNTINGTABLE where \ > USERNAME='%{User-Name}' and \ > ACCTSESSIONID='%{Acct-Session-Id}' and \ > NASIDENTIFIER='%{NAS-IP-Address}' \ > INSERT INTO ACCOUNTINGTABLE \ > USERNAME, ACCTSESSIONID ... VALUES ('%{User-Name}', '%{Acct-Session-Id}' > > Any help would be appreciated. > > Regards > > > Andrew McManus > > Senior NT Systems Engineer > > > > Davnet Telecommunications Pty Ltd > > Level 7, 209 Castlereagh Street > > SYDNEY NSW 2000 > > > > Tel: 61 2 9272 9600 > > Fax: 61 2 9272 9624 > > mailto:[EMAIL PROTECTED] > > www.davnet.com.au > > --------------------------------------------------------- > > Australian General Telecommunications Carrier License No 23 > > --------------------------------------------------------- > > Disclaimer: > > > > Please note that this correspondence is for the named > > person's use only and may contain information that is > > confidential and privileged. > > > > If you received this correspondence in error, please > > immediately delete it from your system and notify > > the sender. Please ensure that you do not disclose, > > copy or rely on any part of this correspondence if > > you are not the intended recipient. We apologise for > > any inconvenience and thank you for your assistance. > > > > Please note that nothing in this correspondence shall > > be construed or otherwise relied upon by the recipient > > as an offer, acceptance of an offer, representation, > > agreement or resolution of any kind. > > --------------------------------------------------------- > > > > > >-- End of excerpt from Andrew McManus -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.