DATE_SUB (rlm_perl)

[Abdul Lateef]

Hi all,
I was inserting start and stop time using rlm_perl
example.pl file. But i am doing some mistake. i
modified the following code for start date, but not
working.

DATE_SUB('CURDATE()',INTERVAL
($RAD_REQUEST{'Acct-Session-Time:-0'} +
$RAD_REQUEST{'Acct-Delay-Time:-0'}) SECOND)

Can anyone suggest me what is the right code to insert
start date and time?

this is the error what i am getting.

/raddb/MaxTime.pl , func = accounting exit status=
DBD::mysql::st execute failed: You have an error in
your SQL syntax near '+ ) SECOND),..............

--------
Yours,
Abdul Lateef
Computer Programmer
HATIF COM
Mob: +974 - 5405022
Tel: +974 - 4883068
ICQ: 276994704
YM!: abdul_zu
Fax: +974 - 4883063
Doha Qatar
http://www.hatif.com


		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com