(RADIATOR) Query in module SQL

[Julio Cesar Pinto]

Hi,

In order to cut the long value that some attributes come from the NAS,
we use substr for example in SessionDatabase we have the following
query:

AddQuery insert into RADONLINE (USERNAME, NAS_IP_ADDRESS, NAS_PORT,
ACCT_SESSION_ID, TIMESTAMP, FRAMED_IP_ADDRESS, NAS_PORT_TYPE,
SERVICE_TYPE, CALLING_STATION_ID, CALLED_STATION_ID, IFX_VISP_ID,
IFX_COUNTRY_ID) values (substr('%u',1,255),'%1',0%2,%3,to_date('%d %m %Y
%H:%M:%S', 'DD MM YYYY
HH24:MI:SS'),'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Service-Type}'
,substr('%{Calling-Station-Id}',1,64),'%{Called-Station-Id}','%{Ifx-Visp
-Id}','%{Ifx-Country-Id}')

substr('%u',1,255)
substr('%{Calling-Station-Id}',1,64)

This work perfect, but now I would like to use the same in AuthBy SQL
but I don't know how to include it in the clause.

Please let me know if we can use it.

Thanks in advance.

Greetings,

JC.


--
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.