(RADIATOR) AcctSQLStatement problem
Mike McCauley
mikem at open.com.au
Tue May 22 08:47:35 CDT 2001
--- Forwarded mail from owner-radiator at open.com.au
From: owner-radiator at open.com.au
Date: Mon, 21 May 2001 08:45:31 -0500
To: radiator-approval at open.com.au
Subject: BOUNCE radiator at open.com.au: Non-member submission from ["adam"
<adam at kccg.com>]
>From mikem at server1.open.com.au Mon May 21 08:45:30 2001
Received: from kccg.com (kccg.com [216.235.110.136] (may be forged))
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id f4LDjUD23154
for <radiator at open.com.au>; Mon, 21 May 2001 08:45:30 -0500
Received: from WEBDEV [168.187.26.236] by kccg.com
(SMTPD32-6.04) id A78360D00052; Mon, 21 May 2001 11:42:59 -0400
Message-ID: <003901c0e20b$d84d0de0$afe3bba8 at kccg.com>
From: "adam" <adam at kccg.com>
To: <radiator at open.com.au>
Subject: AcctSQLStatement problem
Date: Mon, 21 May 2001 18:36:42 +0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0036_01C0E224.FB44BD20"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
This is a multi-part message in MIME format.
------=_NextPart_000_0036_01C0E224.FB44BD20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all
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
can anybody help=20
Thanks all
------=_NextPart_000_0036_01C0E224.FB44BD20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi all</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm constructing a daily based dialup =
connection=20
scheme where every user can connect for different period of time on =
each=20
day</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>so i have in my authentication table =
seven fields=20
each represent a day and each field have the time he is allowed to=20
connect.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>The authentication works fine but i'm =
facing=20
problems in the updating of the information.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>bellow is the : updating the table=20
query</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>AcctSQLStatement update Authentication =
set %Q =3D=20
{%Q}-0%{Acct-Session-Time}, Last =3D '%Q' where USERNAME =3D '%n' And =
Type =3D=20
'H'</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>the following is the error</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT size=3D2>
<P>Mon May 21 18:16:30 2001: DEBUG: do query is: update Authentication =
set=20
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D=20
'H'</P>
<P>Mon May 21 18:16:30 2001: ERR: do failed for 'update Authentication =
set=20
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D=20
'H'': [Microsoft][ODBC Microsoft Access Driver] Syntax error in query =
expression=20
'Monday}-01000'. (SQL-37000)(DBD: st_prepare/SQLPrepare err=3D-1)</P>
<P>Mon May 21 18:16:31 2001: ERR: do failed for 'update Authentication =
set=20
Monday =3D {Monday}-01000, Last =3D 'Monday' where USERNAME =3D 'fred' =
And Type =3D=20
'H'': [Microsoft][ODBC Microsoft Access Driver] Syntax error in query =
expression=20
'Monday}-01000'. (SQL-37000)(DBD: st_prepare/SQLPrepare err=3D-1)</P>
<P> </P>
<P>i think the problem is in %Q=3D{%Q} </P>
<P>can anybody help </P>
<P>Thanks all</P></FONT></DIV></FONT></BODY></HTML>
------=_NextPart_000_0036_01C0E224.FB44BD20--
---End of forwarded mail from owner-radiator at open.com.au
--
Mike McCauley mikem at open.com.au
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
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.
More information about the radiator
mailing list