(RADIATOR) AcctSQLStatement problem

Michael Audet audet at vectorcore.com
Mon May 21 20:17:16 CDT 2001 

You got me....
It's hard to tell from the email but you might want to make sure you have  '
marks around the text you are adding to the database and no ' marks are
required for numbers.

Just a thought..

-Michael Audet
maudet at chubb.com


----- Original Message -----
From: "Mike McCauley" <mikem at open.com.au>
To: <radiator at open.com.au>
Sent: Tuesday, May 22, 2001 9:47 AM
Subject: (RADIATOR) AcctSQLStatement problem


>
> --- 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>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>I'm constructing a daily based dialup =
> connection=20
> scheme where every user&nbsp;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&nbsp;to=20
> connect.</FONT></DIV>
> <DIV>&nbsp;</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>&nbsp;</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>&nbsp;</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.
>

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