(RADIATOR) Hex (Integer8) to Integer conversion within Radiator

[Martin Wallner]

Hi,

If you use bigint on the SQL side, the SQL server should be able to do
this without problems, not needing you to fuss around with
conversions.... you might have to declare the input value as '::hex',
but it should work fine....

Martin Wallner


-----Original Message-----
From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
Behalf Of brian2 at netspeed.com.au
Sent: Mittwoch, 02. Mai 2007 11:05
To: radiator at open.com.au
Subject: (RADIATOR) Hex (Integer8) to Integer conversion within Radiator


Hi Folks,

We have a Redback 1800 SMS which terminates DSL and Wireless
connections.

It has an attribute called RB-Acct-Output-Octets-64 which represents the
number of Acct output octets in Hex format, thus allowing it to record
values greater than the 4 gig restriction on an integer.

I would like to store this value in our SQL Server as an integer (big
integer actually)

Ideally I would like to convert it to a big int within radiator then
store it as part of the acctcolumndef parameters but I don't know how to
do the conversion.

Has anyone done this already or can anyone suggest how I might acheive
this?

Thanks in advance,

Brian Morris



--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au To unsubscribe, email
'majordomo at open.com.au' with 'unsubscribe radiator' in the body of the
message.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.