(RADIATOR) formatted TIME_STAMP in AcctSQLStatement

[Mike McCauley]

Hello Robert,

OK, to make things easy, we have now added a new special character. 
%A is replaced by the Timestamp in standard SQL 
date format eg: Sep 12, 2003 15:48.

(Also %B is replaced by the current time in standard SQL date format eg: Sep 
12, 2003 15:48.)

New patch for Util.pm is available in the usual place.

On Fri, 12 Sep 2003 02:56 pm, Robert Blayzor wrote:
> > > So lets say I'm using MSSQL...
> > >
> > >         DateFormat      %m/%d/%Y %X
> > >         AcctSQLStatement        EXEC sp_acctinsert '%{Acct-S
> > > ession-Id}','%{Acct-Status-Type}','%{User-Name}','%{TimeStamp}'
> > >
> > >
> > > Should insert the TimeStamp as '9/11/2003 21:21:21' ???
> >
> > The only time the DateFormat is used in AuthBy SQL is to
> > format AcctColumnDefs
> > with integer-date types.
> >
> > Timestamp can be got in a number of formats usign special
> > characters like:
> >
> > %b, %o etc.
> >
> > I wonder if a new special character that means 'Timestamp in
> > standard SQL date
> > format' might be useful?
>
> Well that being said.  How am I able to easily pass in a "TimeStamp"
> field in the format I need so that my specific "AcctSQLStatement" can
> insert it however I need it. (see above).  Since stored procedurs use
> argument lists instead of direct insert column/value pairs.
>
> Given above, I need to get TimeStamp into the format above to pass it in
> the argument list.
>
> --
> Robert Blayzor, BOFH
> INOC, LLC
> rblayzor at inoc.net
>
> Exclusive: We're the only ones who have the documentation.

-- 
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, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

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