Hi, I've set up my AcctSQLStatement to look like this:
AcctSQLStatement update RADUSERS set TIMELEFT=TIMELEFT-0%{Acct-Session-Time}, OCTETSINLEFT=OCTETSINLEFT-0%{Ac \ ct-Input-Octets}, OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets} where USERNAME='%n' AcctSQLStatement update RADUSERS set VALIDFROM=now where VALIDFROM IS NULL now the second statement returns this error in the logfile: Mon Jul 21 18:02:49 2003: ERR: do failed for 'update RADUSERS set VALIDFROM=now where VALIDFROM=NULL': Unknown column 'now' in 'field list' -chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 7/18/2003 This Email is protected by RAV AntiVirus Security Software for SuSE Linux eMail Server === 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.