We want to customize some
field in Log SQL, for example we want the fields like this:
TIME_STAMP datetime
NASIPADDRESS
varchar(50)
MESSAGE_TYPE
int (Warning,Debug etc)
MESSAGE varchar(255)
but in
documentation, I read that the log table must have format
like:
insert into
tablename
(TIME_STAMP, PRIORITY, MESSAGE)
values (time
, priority
, 'message
')
(TIME_STAMP, PRIORITY, MESSAGE)
values (time
, priority
, 'message
')
Is it possible to
customize SQL command (insert into ....), or add some parameters in to SQL
command, such as NASIPADDRESS, Client IP Address etc ...?
Thanks in
advance.
Le Anh Tuan
Netnam Company
R&D group
email: [EMAIL PROTECTED]
www: http://www.netnam.vn