(RADIATOR) question

[Chris Garzon]

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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.