(RADIATOR) additional query

[Mike McCauley]

Hello,


On Mon, 9 Jun 2003 05:01 pm, budi wibowo wrote:
> hi i have
> <Realm dbku>
>    AcctLogFileName              %L/detail
>    <AuthBy SQL>
>     DBSource                dbi:mysql:rad
>     DBUsername              xxx
>     DBAuth                  xxx
>
>     AuthSelect
>     AccountingTable accouting
>       -----snipped---
>     AcctColumnDef actsessiontime,Acct-Session-Time
>       ----snipped--
> </Realm>
>
>
> how can i add new field in mysql named time_bill where
> time_bill=actsessiontime + 30;

If you just want to calculate actsessiontime + 30, you dont need a new column. 
You can do the addition when youy get the data back in your select:

select xxx,yyy,actsessiontime + 30,zzz from ppp ......

Cheers.

>
>
> thx
>
>
> budi
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.yahoo.com
> ===
> 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.

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