(RADIATOR) Integer8 and AcctInsertQuery

[Herman verschooten]

Hi,
 
I am having a small problem... I am trying to execute a stored procedure
using AcctSQLStatement as such
 
 
AcctSQLStatement exec AddSession
'%{Acct-Session-Id}','%{User-Name}',%{RB-Acct-Input-Octets-64},%{RB-Acct
-Output-Octets-64}
 
Now I have 2 problems... First, If there is not Accounting information
Radiator just blanks it out, second these values are in a hexidecimal
format (0x01234) which SQL does not convert to a numeric value.
 
So I tried to use the AcctInsertQuery but how can I define which column
comes where in my statement if I use AcctColumnDef ?
 
AccountingTable TEST
AcctColumnDef    AcctSessionID, Acct-Session-Id
AcctColumnDef    CallDate, Timestamp, integer
AcctColumnDef    Username, User-Name
AcctColumnDef    AcctInputOctets,Acct-Input-Octets, integer
AcctColumnDef    AcctOutputOctets,Acct-Output-Octets, integer
AcctColumnDef    AcctInputOctets,RB-Acct-Input-Octets-64, integer
AcctColumnDef    AcctOutputOctets,RB-Acct-Output-Octets-64, integer
AcctInsertQuery exec AddSession %2
 
Thanks,
 
Herman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20040706/c2b028cf/attachment.html>