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 [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. -- Mike McCauley [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
