Trembowiecki
Member
Hi,
here's my problem: I have a list which contains element with IP addresses (it's VARCHAR, because the addresses have added brackets, wildcards etc.). I wanted MySQL to order the IP properly, so I used workaround (table view with modified select). The thing is - 'ip_address' is also my search filter (autocomplete list), but when I type an IP, I don't want to have only the one matching record displayed, I'd like to have displayed - say - 5 IP addresses that are on the list before searched IP and 5 IPs that are on the list after the searched IP. And when I write 'list', I mean the 'quasi' list that is conneced to a table view and have IPs in the right order.
IP addresses are being added in random order, so record ID have to use here, I'm afraid.
For example, if I have in my table IPs from 192.168.100.1 to 192.168.100.255 and in search filter I type '192.168.100.30', in the search results in list view I'd like to see records with IPs from 192.168.100.25 to 192.168.100.35.
Do you know how to achieve this?
Cheers,
Olek
here's my problem: I have a list which contains element with IP addresses (it's VARCHAR, because the addresses have added brackets, wildcards etc.). I wanted MySQL to order the IP properly, so I used workaround (table view with modified select). The thing is - 'ip_address' is also my search filter (autocomplete list), but when I type an IP, I don't want to have only the one matching record displayed, I'd like to have displayed - say - 5 IP addresses that are on the list before searched IP and 5 IPs that are on the list after the searched IP. And when I write 'list', I mean the 'quasi' list that is conneced to a table view and have IPs in the right order.
IP addresses are being added in random order, so record ID have to use here, I'm afraid.
For example, if I have in my table IPs from 192.168.100.1 to 192.168.100.255 and in search filter I type '192.168.100.30', in the search results in list view I'd like to see records with IPs from 192.168.100.25 to 192.168.100.35.
Do you know how to achieve this?
Cheers,
Olek