Sorting ip address for dynamic table

Cool, how?


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

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.

^^^ i found that the other day, and quickly found that it didn't work.

thanks for the help guys.

What is the error that you get from using above code?

this is the error I get when testing the code:

[microsoft][obdc MS access driver] Syntax error (missing operator) in query expression 'CAST(PARSENAME(radio_ip, 4) ASINT)'

thanks, mark

[microsoft][obdc MS access driver] Syntax error (missing operator) in query expression 'CAST(PARSENAME(radio_ip, 4) ASINT)'

that's the error I get

http://www.aspfaq.com/downloads/ASPFAQ-2006-04-18.pdf

http://www.aspfaq.com/downloads/ASPFAQ-2006-04-18.pdf

..oO(relecom)

this is the error I get when testing the code:

[microsoft][obdc MS access driver] Syntax error (missing operator) in
query expression 'CAST(PARSENAME(radio_ip, 4) ASINT)'

Where's the 'ASINT' coming from? Shouldn't that be 'AS INT' instead?

Micha

yes it is AS INT, I had to retype the error, it was my typo.

Mark

-- Access:
SELECT CINT(column)
-- SQL Server:
SELECT CAST(column AS INT)

Try this:
SELECT [radio_ip] FROM [sc_survey]
ORDER BY CINT(PARSENAME([radio_ip], 4) AS INT),
CINT(PARSENAME([radio_ip], 3) AS INT),
CINT(PARSENAME([radio_ip], 2) AS INT),
CINT(PARSENAME([radio_ip], 1) AS INT)

Not sure, never tried to sort Ip addresses but am intereste in helping you
solve this.