(RADIATOR) Update Not working

[Ronan Eckelberry]

Shaun,

	The syntax look right.  It is case sensative though...make sure
you have everything in the same case that is is in your database.  It
might help for you to reply to the list with a Trace of the Radiator
log.

-Ronan

-----Original Message-----
From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
Behalf Of Shaun Eck
Sent: Tuesday, 19 February, 2002 15:43
To: radiator at open.com.au
Subject: (RADIATOR) Update Not working 



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>

===
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.