Hello Rose,

maybe you should update SUBSCRIBERS table instead of ACCOUNTING..  i
bet, that's where your MAXTIME column is..

HTH.


"Rose P. San juan" wrote:

>         AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
>         AcctColumnDef TIME_STAMP,Timestamp,formatted-date,to_date(''%e %m%Y %
>         AcctSQLStatement update ACCOUNTING set 
>MAXTIME=MAXTIME-0%{Acct-Session-Time},OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets},
>         OCTETSOUTLEFT=OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets}
>         where USERNAME='%n'

-- 
.._.,+=~`^"-.,,.-"^'~=+,.__.,+=~`^"-.,,.-"^'~=+,.__.,+=~`^"-,,

darwin a. bawasanta  [EMAIL PROTECTED]  pgp-id: 0x367CADAC
SKYinternet incorporated philippines    http://www.skyinet.net
mobile: +63 917.322.6299    pager: ec# 963589    marsma|ow@IRC
.._.,+=~`^"-.,,.-"^'~=+,.__.,+=~`^"-.,,.-"^'~=+,.__.,+=~`^"-,,
"The essence of intelligence is skill in extracting meaning 
                    from everyday experience."

===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to