Hi ZM,
Thanks for the info.
My temporary workaround for the time format is:-
CONCAT(MID('%{connect-time}',1,11), ' ', RIGHT('%{connect-time}',12))
That would give me a string like:-
Jun 14 2005 01:56:53.000
instead of:-
Jun 14 2005 Malay Peninsula Time 01:56:53.000
Better still would have been:-
CONCAT(
MID('%{connect-time}',8,4),
MID('%{connect-time}',5,2),
LPAD(FIELD(MID('%{connect-time}',1,3),
'Jan','Feb','Mar'.'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),2,'
0'),
REPLACE(MID(RIGHT('%{connect-time}',12),1,8),':','')
)
That would give us:-
20050614015653
As for the Dialled number - apart from a reverse lookup - there seems to be
no elegant way!
Regards,
Ap.Muthu
>From: "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx>
>Date: Tue, 14 Jun 2005 09:45:49 +0200
>At least in the latest 2.2 cvs there is a TimestampFormat
>config option and a %{Dialed-Number} variable.
>In 2.0.9 they may be not available (if not mentioned in the manual).
>----- Original Message -----
>From: "Ap.Muthu" <apmuthu@xxxxxxx>
>Sent: Tuesday, June 14, 2005 7:23 AM
>>I tried the v2.09 stock win32 binary with MySQL v4.0.24 - used it's
>> lib\opt\libmySQL.dll in the same folder (is it necessary?).
>>
>> What is the % variable to get the number as dialled (before
Rewrite::E164)
>> into the MySQL CDR?
>>
>> How do i get the MySQL TimeStamp instead of the current format of
>> '%{setup-time}', '%{connect-time)', etc. ?
>>
>> Is there an updated list of % variables?
>>
>> Thanks and Regards,
>> Ap.Muthu
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________________
Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
