(RADIATOR) Question about AcctSQLStatement.

[Sergio Gonzalez]

*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hello.

I'm having problems with the next SQL statement for accounting

AcctSQLStatement update TABLENAME set VALUE=0%{Acct-Session-Time} where 
ROW='%n' and
DATE_FORMAT(FROM_UNIXTIME(0%{Timestamp},'%d-%m-%y') = 'mm-dd-yy'

where mm-dd-yy is a date value in that format. Well, if I do in mysql 
(obviously replacing %0{Timestamp} for a valid value):

SELECT DATE_FORMAT(FROM_UNIXTIME('01035767266','%d-%m-%y') = 'mm-dd-yy';

it works well. The format of the 
FROM_UNIXTIME(0%{Timestamp}-0%{Acct-Session-Time}) is rewrited like 
mm-dd-yy and then I can compare them, but the problem is when I try to do 
the same SQL statement with radius;  the %d, %m and the %y don't mean the 
same. Those "wildcards" are being interpreted like the actual day month and 
year of the box running radius.

How do I escape or make radius send to mysql the string "%d-%m-%y" without 
interpret them?.


Sergio Alejandro Gonzalez
Director Operativo
Network and Services Field Manager
SkyNet de Colombia.
Calle 100 No. 8A-55 Of. 711
Bogota, Cundinamarca
Colombia, South America.
Tel: 57 (+1) 6 422 020
Cel: 57 (+3)/(03315) 3551034
Pager: 5405555, 3469999 Cod 2010

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