Reply to thread

Message

<blockquote data-quote="chakal24" data-source="post: 298534" data-attributes="member: 80145">Hey Kev!I'm still having issues with the sorting by channel. It either doesn't work or doesn't use the right field. I'm using a DVB-S card, and my channel are numbered by SID. These numbers are stored in the TuningDetail table, the column name is channelNumber. Here is a sample channel taken from the DB:idTuning&nbsp; &nbsp; idChannel&nbsp;&nbsp; name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; channelType channelNumber frequency&nbsp;&nbsp; countryId&nbsp;&nbsp; isRadio isTv&nbsp; networkId&nbsp;&nbsp; transportId serviceId&nbsp;&nbsp; pmtPid&nbsp; &nbsp; &nbsp; freeToAir modulation&nbsp; polarisation symbolrate&nbsp; diseqc&nbsp; &nbsp; &nbsp; switchingFrequency bandwidth&nbsp;&nbsp; majorChannel minorChannel pcrPid&nbsp; &nbsp; &nbsp; videoSource tuningSource videoPid&nbsp; &nbsp; audioPid&nbsp; &nbsp; band&nbsp; &nbsp; &nbsp; &nbsp; satIndex&nbsp; &nbsp; innerFecRate pilot&nbsp; &nbsp; &nbsp;&nbsp; rollOff&nbsp; &nbsp;&nbsp; url bitrate----------- ----------- --------------- --- ----------- ------------- ----------- ----------- ------- ----- ----------- ----------- ----------- ----------- --------- ----------- ------------ ----------- ----------- ------------------ ----------- ------------ ------------ ----------- ----------- ------------ ----------- ----------- ----------- ----------- ------------ ----------- ----------- --- -----------1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; CKPG&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 260&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 12224000&nbsp; &nbsp; 31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp;&nbsp; 257&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 101&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 260&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 32&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20000&nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 11700000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0(1 row(s) affected)Could it be possible to either sort by the channel number, or append it to the channel name and sort it that way?</blockquote>

[QUOTE="chakal24, post: 298534, member: 80145"] Hey Kev! I'm still having issues with the sorting by channel. It either doesn't work or doesn't use the right field. I'm using a DVB-S card, and my channel are numbered by SID. These numbers are stored in the TuningDetail table, the column name is channelNumber. Here is a sample channel taken from the DB: idTuning idChannel name channelType channelNumber frequency countryId isRadio isTv networkId transportId serviceId pmtPid freeToAir modulation polarisation symbolrate diseqc switchingFrequency bandwidth majorChannel minorChannel pcrPid videoSource tuningSource videoPid audioPid band satIndex innerFecRate pilot rollOff url bitrate ----------- ----------- --------------- --- ----------- ------------- ----------- ----------- ------- ----- ----------- ----------- ----------- ----------- --------- ----------- ------------ ----------- ----------- ------------------ ----------- ------------ ------------ ----------- ----------- ------------ ----------- ----------- ----------- ----------- ------------ ----------- ----------- --- ----------- 1 1 CKPG 3 260 12224000 31 0 1 257 101 260 32 0 -1 2 20000 0 11700000 8 -1 -1 0 0 0 0 0 9 -1 6 -1 -1 0 (1 row(s) affected) Could it be possible to either sort by the channel number, or append it to the channel name and sort it that way? [/QUOTE]

Verification