Hello Vangelis -
Could you explain to me what you are trying to do? In other words, what value are you trying to calculate?
thanks
Hugh
On Monday, Jan 20, 2003, at 23:29 Australia/Melbourne, Vangelis Kyriakakis wrote:
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
