This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
> You can add a custom function which calls the dotted IP to IP function.
yeah, thats what I was hoping to avoid.
So, my solution is to use awk to snarf the IP addresses from csv file before
import
and the convert to long IP a
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
This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
> I suspect that you might find these blocks to be networks and subnets
> and consequently identified by the octets in the dotted IP.
yes, they would be nets and subnets.
But how to identify them or single out a net/subnet?
Ki
This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
> Are you actually searching for membership in a class A, B or C network
> or perhaps a subnet? If you are you can use the dotted format to your
> advantage.
No, The search is for which registry owns the block of IPs the that
This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
> It looks as if you are looking to see if an address belongs to a
> particular class B network. Are all your searches done that way?
>
> If they are you may be able to use a regular expression to do your search.
well, the r
This one time, at band camp, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
> ip between '81.163.0.0' and '81.163.999.999'
This would require me know the value of the range before selecting.
The addittion of the IP plus the range is what gets me. How to
go about it?
Kind regards
Kevin
--
"Democra
This one time, at band camp, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
> I don't quite understand. To continue your example, exactly which IP
> addresses are considered to fall into the range "65536"? How do you
> figure 1.2.3.4 is in this range, if indeed it is?
The begging IP may be 81.163.0.
This one time, at band camp, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
> How is the range specified?
In the database the IP is 1.2.3.4 and the range is eg: 65536
Kind regards
Kevin
--
"Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contest
How can I SELECT an IP within a range?
All my IP's are stored as 1.2.3.4 but I need to check if
each is within a range of long IP's.
Can this be done with SQLite? or do I need some sort of
external ip2long() function to throw at it?
Kind regards
kevin
--
"Democracy is two wolves and a lamb voti
This one time, at band camp, "yuyen" <[EMAIL PROTECTED]> wrote:
> HI, JC
> I use php_do_sqlite with PHP 5.1.4 and Sqlite 3.2.8 on Windows XP. The
> following is my coding:
-8< snip
try {
$dbh = new PDO("sqlite:counter/cntdata.sq3";
/*** echo a message s
This one time, at band camp, Ivan Voras <[EMAIL PROTECTED]> wrote:
> On my platform (FreeBSD) the bundled version is not
> used by default so that's how I came to the wrong
> conclusion. If you can rebuild it from scratch, maybe
> you also can exclude the bundled library.
Other than this, you cou
al&ie=UTF-8&oe=UTF-8&hl=en&btnG=Google+Search&meta=
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_|
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \)
Kevin Waterson
Port Macquarie, Australia
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
these items in this mail?
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \____)
Kevin Waterson
Port Macquarie, Australia
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
uage),
lol :)
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \____) \____)
Kevin Waterson
Port Macquarie, Australia
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-m
in php4.
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \)
Kevin Waterson
Port Macquarie, Australia
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
he year.
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \)
Kevin Waterson
Port Macquarie, Australia
-
To unsubscribe, e-mail: [EMAIL PROTEC
This one time, at band camp, Kevin Waterson <[EMAIL PROTECTED]> wrote:
> > I thought I would ask before starting one
>
> http://sourceforge.net/projects/sqlite-admin/
screen shots here...
http://ww
rojects/sqlite-admin/
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \)
Kevin Waters
rds
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \____)
Kevin Waterson
Port Macquarie, Australia
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional command
your time.
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \____) \_||_| \) \)
Kevin Waterson
Port Macquarie, Australia
-
To unsubscribe, e-mail: [
This one time, at band camp, Kevin Waterson <[EMAIL PROTECTED]> wrote:
> OK, that sounds fine, but is it possible to determine the type of field so my script
> will be able to add the quotes if it is of type INTEGER?
I guess what I really need is something like MySQL's mysql_f
add the quotes if it is of type INTEGER?
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \)
Kevin Waterson
Port Macquarie, Australia
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
g something wrong/insane here.
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \)
Kevin Waterson
Port Macquarie, Australia
--
morrow and any other messages are
archived with the current system?
Kind regards
Kevin
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \
bscribe if that
> is your choice.
Seems to work fine :)
--
__
(_ \
_) )
| / / _ ) / _ | / ___) / _ )
| | ( (/ / ( ( | |( (___ ( (/ /
|_| \) \_||_| \) \)
K
27 matches
Mail list logo
