Kevin Waterson wrote:
This one time, at band camp, "Trevor Talbot" <[EMAIL PROTECTED]> wrote:
I'd store the IPs in the DB in integer form as Lloyd suggested, if
range queries are your goal. Do conversion to and from display format
in the application.
Yes, they are stored as INTEGER. and the conversion outside sqlite
is simple. However, I still need to SELECT the range before displaying.
And without doing SELECT *
maybe I should use MySQL and NET_ATON / INET_NTOA
but it would be much nicer and portable in SQLite
Kind regards
Kevin
You can add a custom function which calls the dotted IP to IP function.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
