matching on IP Address

King, Adam adam.king at intechnology.com
Tue Jun 17 12:15:43 CEST 2008


Hi, 
I am running this query:
if ("%{sql: SELECT COUNT(nas_ip) FROM `nas_ip` WHERE
nas_ip='127.0.0.1'}">0){
redundant {
sql1
sql2
}
}

But the if ("%{sql: SELECT COUNT(nas_ip) FROM `nas_ip` WHERE
nas_ip='127.0.0.1'}">0) section always returns false even though the
database has the 'nas_ip' table containing 127.0.0.1 as the data
Any ideas? 
Thanks 
 

Adam King
Network Engineer
adam.king at intechnology.com


InTechnology plc
Support 0845 120 7070
Telephone 01423 850000
Facsimile 01423 858866
www.intechnology.com
* Harrogate, Reading, London
* 200 people, ?50m p.a. turnover
* Over 500 corporate clients
* Specialist Business Solutions & Services Provider


This is an email from InTechnology plc, Central House, Beckwith Knowle, Harrogate, UK, HG3 1UG. Registered in England 3916586.

The contents of this message may be privileged and confidential. If you have received this message in error, you may not use,

disclose, copy or distribute its content in anyway. Please notify the sender immediately.

All messages are scanned for all viruses.




More information about the Freeradius-Users mailing list