(RADIATOR) Update Not working

[Shaun Eck]

Hi

I have tried updating the balancetime in the Database, however it is not working, could you please tell me what I am doing wrong.

Regards

<Realm  sql.realm>

RewriteUsername s/^([^@]+).*/$1/

<AuthBy SQL>

    Identifier SQL

    DBSource dbi:Informix:tis

    DBUsername  xxxxxx

    DBAuth xxxxxx

AuthSelect select password, balancetime from subscribers where (username='%n' and balancetime > 0)

AuthColumnDef     0,Password,check

AuthColumnDef     1,Session-Timeout,reply

AddToReply     Service-Type = Framed-User,Framed-Protocol = PPP

AcctSQLStatement update subscribers set balancetime = balancetime-0%{Acct-Session-Time}  where username = '%n"

</AuthBy>

</Realm>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020219/1f7e98b0/attachment.html>