(RADIATOR) AcctSQLStatement problem

[Hugh Irvine]

Hello Adam -

>
> I'm constructing a daily based dialup connection scheme where every user =
> can connect for different period of time on each day
> so i have in my authentication table seven fields each represent a day =
> and each field have the time he is allowed to connect.
>
> The authentication works fine but i'm facing problems in the updating of =
> the information.
> bellow is the : updating the table query
> AcctSQLStatement update Authentication set %Q =3D =
> {%Q}-0%{Acct-Session-Time}, Last =3D '%Q' where USERNAME =3D '%n' And =
> Type =3D 'H'
>
> the following is the error
> Mon May 21 18:16:30 2001: DEBUG: do query is: update Authentication set =
> Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
> And Type =3D 'H'
>
> Mon May 21 18:16:30 2001: ERR: do failed for 'update Authentication set =
> Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
> And Type =3D 'H'': [Microsoft][ODBC Microsoft Access Driver] Syntax =
> error in query expression 'Monday}-01000'. (SQL-37000)(DBD: =
> st_prepare/SQLPrepare err=3D-1)
>
> Mon May 21 18:16:31 2001: ERR: do failed for 'update Authentication set =
> Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
> And Type =3D 'H'': [Microsoft][ODBC Microsoft Access Driver] Syntax =
> error in query expression 'Monday}-01000'. (SQL-37000)(DBD: =
> st_prepare/SQLPrepare err=3D-1)
>
>
>
> i think the problem is in %Q=3D{%Q}=20
>

Yes - it should just be this:

	.... %Q = %Q-0%{Acct-Session-Time}, ....

hth

Hugh

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.