matching on IP Address

[Ivan Kalik]

Is that table in the database sql instance is connecting to?

Ivan Kalik
Kalik Informatika ISP


Dana 17/6/2008, "King, Adam" <adam.king at intechnology.com> piše:

>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.
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>