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

-- 
"Democracy is two wolves and a lamb voting on what to have for lunch. 
Liberty is a well-armed lamb contesting the vote."

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to