Iron Speed Technical Forums
Register Latest Topics
 
 
 


Reply
  Author   Comment  
Gizmoz

Registered:
Posts: 4
Reply with quote  #1 
How to order a table by ip adresses ? in tsql i could do somthing like this

SELECT *
FROM MyTable
ORDER BY CAST(PARSENAME(REPLACE(Data, ':', '.'), 4) as int),
    CAST(PARSENAME(REPLACE(Data, ':', '.'), 3) as int),
    CAST(PARSENAME(REPLACE(Data, ':', '.'), 2) as int),
    CAST(PARSENAME(REPLACE(Data, ':', '.'), 1) as int)


 
how do i do this in Ironspeed ? 

when selecting order by i can only select tabel and field to order by

__________________
Regards

Johnny
JimiJ

Avatar / Picture

MVP Developer
Registered:
Posts: 1,954
Reply with quote  #2 
You may create a view source with concat column to combine those casted data and use it for sorting order.
__________________

  Jaime Jegonia
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

Gizmoz

Registered:
Posts: 4
Reply with quote  #3 
isen't it possible to find the select statement and alter the
request ?

in ISD 9.x the order by is only for display, but it must be possible to find and alter the request or ?

__________________
Regards

Johnny
JimiJ

Avatar / Picture

MVP Developer
Registered:
Posts: 1,954
Reply with quote  #4 
I'm sorry. I can't help you much because ISD 9X is no longer installed in my development PC.
__________________

  Jaime Jegonia
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.

Download Iron Speed Designer

Terms of Service Privacy Statement