(RADIATOR) Using AcctSQLStatement with integer-date format

[Vangelis Kyriakakis]

Hi again,

I'm trying to use something like

AcctColumnDef CONNECTTIME,%b-0%{Acct-Session-Time},integer-date

but it doesn't work. It gives a NULL value for the CONNECTTIME attribute.
I have also tried AcctColumnDef
CONNECTTIME,%{Timestamp}-0%{Acct-Session-Time},integer-date

If I write AcctColumnDef CONNECTTIME,Timestamp,integer-date it works, but
ofcourse it's not what I want.
I want to use this attribute with Sybase Datetime type

             Regards
                  Vangelis

Hugh Irvine wrote:

> Hello Vangelis -
>
> You should use AcctColumnDef's for what you show below.
>
> See section 6.28.14 in the Radiator 3.5 reference manual.
>
> regards
>
> Hugh
>
> On Saturday, Jan 18, 2003, at 02:55 Australia/Melbourne, Vangelis
> Kyriakakis wrote:
>
> > Hello,
> >
> >      I want to write the following AcctSQLStatement:
> >
> > AcctSQLStatement insert into TABLE (LOGIN_TIME, LOGOUT_TIME,.....)
> > values
> > (%{Timestamp}-%{Acct-Session-Time}Formatted using integer-date and
> > (%Y%m%d %H:%M) Format,%{Timestamp}Formatted using integer-date and
> > (%Y%m%d %H:%M) Format,.......)
> >
> >      How should I write the above SQL query? I have read the manual but
> > I cannot figure out the exact format of the query.
> >
> >              Regards
> >                  Vangelis
> >
> > ===
> > 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.
> >
> >
>
> --
> 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.