Sorting ip address for dynamic table

^^^ wouldn't that only work if the ip addresses were entered into the database in the correct order? and I can't change the structure of the database.

thanks for the help,. Mark

How can you be wanting to sort someone elses database?

How do these "IP Addresses" get in the database?

it's an existing database, I just can't change the structure at all.

Mark

You didn't answer my second question.
How do they get in the database?

they are manually entered in.

Mark

Try this:

SELECT [radio_ip] FROM [sc_survey]
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)


Otherwise add a field called sortorder.

..oO(relecom)

[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?

Not really, since I haven't done it before myself. It was just an idea,
since the algorithm to convert an IP to an integer is quite simple. It
should be possible to implement that with pure SQL or maybe in a stored
procedure.

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)

Also looks good and correct from my understanding, but I'm not familiar
with Access or MS SQL Server.

but it yields an error.

It always helps to not just say that there was an error, but to post the
actual and complete error message ...

Micha

What is the error?


"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

Try this:

SELECT [radio_ip] FROM [sc_survey]
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)

He is using MS Access. PARSENAME() is t-sql. You will need to use different
method to parse the ip.