Sorting ip address for dynamic table

I am trying to sort an ip address coloumn, and it't working but not sorting
properly.

SQL:

SELECT radio_ip
FROM sc_survey
WHERE radio_ip LIKE MMColParam%
ORDER BY radio_ip ASC

as you cvan see it's sorting, but not in order

what is the proper format to sort ip addresses in actual order?

thanks, Mark

I know for a fact that I saw a link here to a javascript code that could do
what you need.
I can't remember the name though.

Cheers


"relecom" <webforumsuser (AT) macromedia (DOT) com> wrote

I am trying to sort an ip address coloumn, and it't working but not sorting
properly.

SQL:

SELECT radio_ip
FROM sc_survey
WHERE radio_ip LIKE MMColParam%
ORDER BY radio_ip ASC

as you cvan see it's sorting, but not in order

what is the proper format to sort ip addresses in actual order?

thanks, Mark

..oO(relecom)

I am trying to sort an ip address coloumn, and it't working but not sorting
properly.

SQL:

SELECT radio_ip
FROM sc_survey
WHERE radio_ip LIKE MMColParam%
ORDER BY radio_ip ASC

as you cvan see it's sorting, but not in order

what is the proper format to sort ip addresses in actual order?

Just an idea:

You could store the IP addresses as 32bit integers instead of strings or
convert from string representation to integer before sorting.

You can find explanations and algorithms for doing that on Google, for
example

http://www.aboutmyip.com/AboutMyXApp/IP2Integer.jsp

Micha

anyone else? I can't cdhange how the ip's are stored in the database, I only have control over the ASP side.

regards,

..oO(relecom)

anyone else? I can't cdhange how the ip's are stored in the database, I
only have control over the ASP side.

You could still do it in SQL and perform the IP <-> INT conversion when
fetching the results ...

Micha

[q]Originally posted by: Newsgroup User
.oO(relecom)

anyone else? I can't cdhange how the ip's are stored in the database, I
only have control over the ASP side.

You could still do it in SQL and perform the IP <-> INT conversion when
fetching the results ...

Micha
[/q]

can you elaborate on that?

I was told to use this code:

ORDER BY CAST(PARSENAME(Radio_ip, 4) AS INT),
CAST(PARSENAME(Radio_ip, 3) AS INT),
CAST(PARSENAME(Radio_ip, 2) AS INT),
CAST(PARSENAME(Radio_ip, 1) AS INT)


but it yields an error.

thanks guys, Mark

What dbms are you using?

a ms access database, coding with ASP vb.

mark

Very simple:

Add a field called "sortorder" a number field
Allow only 3 characters and sort using that.

SQL:

SELECT radio_ip
FROM sc_survey
WHERE radio_ip LIKE MMColParam%
ORDER BY sortorder ASC

OR

SELECT radio_ip
FROM sc_survey
WHERE radio_ip LIKE MMColParam%
ORDER BY sortorder DESC

Pick one. That solves all your issues.
Cheers




"relecom" <webforumsuser (AT) macromedia (DOT) com> wrote

anyone?

Mark

Sorry didn't read your post properly but this is very, very simple:

Add a field called "sortorder" a number field
Allow only 3 characters and sort using that.

SQL:

SELECT radio_ip
FROM sc_survey
WHERE radio_ip LIKE MMColParam%
ORDER BY sortorder ASC

OR

SELECT radio_ip
FROM sc_survey
WHERE radio_ip LIKE MMColParam%
ORDER BY sortorder DESC

Pick one. That solves all your issues.
Cheers

[q]Originally posted by: relecom
I am trying to sort an ip address coloumn, and it't working but not sorting
properly.

SQL:

SELECT radio_ip
FROM sc_survey
WHERE radio_ip LIKE MMColParam%
ORDER BY radio_ip ASC

as you cvan see it's sorting, but not in order

what is the proper format to sort ip addresses in actual order?

thanks, Mark[/q]