Hello List And Hugh I have a problem, I am trying to set up our session database without much success. I am using SessionDatabase SQL.
The current field in my Online table for input and output octects is BIGINT, (SQL SERVER) This is working fine except for the fact when we get a user that is download over 2 gig in any one session. After this we get an Arithimic overflow error. This is my query below: AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \ ACCTSESSIONID, FRAMEDADDRESS, AccInputOctets, AccOutputOctets, \ SERVICETYPE,NASPortDNIS,callerid,AscendKey) values ('%n', '%N', %{NAS-Port}, '%{Acct-Session-Id}', \ '%{Framed-IP-Address}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', \ '%{Service-Type}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Ascend-S ession-Svr-Key}') notice how %{Acct-Input-Octets}and %{Acct-Output-Octets} are enclosed by '', This is a problem, I tried converting our fields in the database to numeric so we could handle the data coming through, but then the sql statement errored as i thought it would saying error converting varchar to numeric. So i took away the '' around the two values, and after I did that the values disappeared. Without the quotes %{Acct-Input-Octets} and %{Acct-Output-Octets} return empty values. Even if I try to cast the value as numeric it still comes back as empty. IN casting numeric I mean this AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \ ACCTSESSIONID, FRAMEDADDRESS, AccInputOctets, AccOutputOctets, \ SERVICETYPE,NASPortDNIS,callerid,AscendKey) values ('%n', '%N', %{NAS-Port}, '%{Acct-Session-Id}', \ '%{Framed-IP-Address}', cast('%{Acct-Input-Octets}' as numeric), cast('%{Acct-Output-Octets}' as numeric), \ '%{Service-Type}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Ascend-S ession-Svr-Key}') this Still causes the values to return empty. The values are returning empty becuase I print out the sql string before execution.... Any help in this matter would be very much appreciated. Thanks everyone Kind Regards Nathan Franklin TSN Internet [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] 'I do not regret the things I have done, but those I have left undone.' === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.