<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial size=2><SPAN
class=914512616-01052006>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=914512616-01052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=914512616-01052006>I having a problem
storing repeated Attributes in to a Microsoft Sql Database. My Start
record gets logged like this:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=914512616-01052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=914512616-01052006>
Acct-Status-Type = Start<BR>
NAS-IP-Address = 127.0.0.254<BR>
NAS-Port = 5060<BR> Acct-Session-Id =
"<A
href="mailto:D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139">D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139</A>"<BR>
Session-Ingress-CallId = "<A
href="mailto:D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139">D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139</A>"<BR>
Session-Egress-CallId = "<A
href="mailto:D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139">D747CE74-A671-4C07-B583-EB44CA534966@10.10.1.139</A>"<BR>
Session-Protocol-Type = "SIP"<BR>
Calling-Station-Id = "Test"<BR>
Called-Station-Id =
"<sip:XXXXXXXXXX@127.102.0.117>"<BR>
h323-setup-time = "18:01:42.091 UTC APR 28
2006"<BR> h323-connect-time =
"18:01:42.119 UTC APR 28 2006"<BR>
Session-Egress-Realm = "b11"<BR>
Session-Ingress-Realm = "p11"<BR>
FlowID = "localhost:65616"<BR>
FlowType = "PCMA"<BR> Flow-In-Realm =
"p11"<BR> Flow-In-Src-Addr =
0.0.0.0<BR> Flow-In-Src-Port =
0<BR> Flow-In-Dst-Addr =
10.2.35.117<BR> Flow-In-Dst-Port =
49232<BR> Flow-Out-Realm =
"b11"<BR> Flow-Out-Src-Addr =
10.2.19.117<BR> Flow-Out-Src-Port =
49232<BR> Flow-Out-Dst-Addr =
0.0.0.0<BR> Flow-Out-Dst-Port =
0<BR> FlowID =
"localhost:65617"<BR> FlowType =
"PCMA"<BR> Flow-In-Realm =
"b11"<BR> Flow-In-Src-Addr =
0.0.0.0<BR> Flow-In-Src-Port =
0<BR> Flow-In-Dst-Addr =
10.2.19.117<BR> Flow-In-Dst-Port =
49232<BR> Flow-Out-Realm =
"p11"<BR> Flow-Out-Src-Addr =
10.2.35.117<BR> Flow-Out-Src-Port =
49232<BR> Flow-Out-Dst-Addr =
10.10.1.139<BR> Flow-Out-Dst-Port =
49228<BR> Client-IP-Address =
10.1.0.33<BR> Acct-Unique-Session-Id =
"bfbfead8e14980c1"<BR> Timestamp =
1146246538<BR></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=914512616-01052006>Notice how the
FlowID attribute is logged twice but have different values How do I
reference the second occurance of FlowID i.e %{FlowID} in my SQL statement in my
mssql.conf? I created two new columns in my sql database called FlowID1
and FlowID2.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=914512616-01052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=914512616-01052006>
accounting_update_query = "INSERT into ${acct_table1} (AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, FlowID1, FlowID2)
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}',
'%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}',
'%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Acct-Input-Octets}',
'%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}',
'%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0',
'%{FlowID}', '%{FlowID}')"<BR></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=914512616-01052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=914512616-01052006> </DIV></SPAN></FONT></BODY></HTML>