How to prevent sorting in the auto-complete popup ?

[krunchParticipant]

Hi

My autocompletion php script retrieves sorted datas according to an invisible ‘rank’ parameter (not returned to the request) :

$sql = "SELECT CPOST, VILLE FROM fr WHERE 	CPOST LIKE :q2 
						OR
						VILLE LIKE :q2
						ORDER BY rank DESC LIMIT 8";

But the ‘source’ order is modified into the auto-complete popup : the order is not the same regarding the items order in response($.map(data, function (item) ….

Can I prevent this sorting ?
Thanks in advance

[Peter StoevKeymaster]

Hi krunch,

There is no API for preventing the sorting. It is by design.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[krunchParticipant]

Thanks ..
This is a bad new, it means that I have to forget my initial sorting (wich is relevant) or to forget jQWidgets

[krunchParticipant]

I get a very strange thing about the auto-complete popup order :
– if I enter ‘N’ the items are sorted according to my order (ie they are note sorted by the popup)
– if I enter ‘n’ the items are sorted according to another order (ie they are sorted)

So I tried the following hacks on client side :
data.in = query.substr(0,1).toUpperCase() + query.substr(1);
And on server side :
$in = strtoupper($in[0]) . substr($in, 1);
But none are working !

It means that the items are not sorted if I press on the SHIFT key ..

[Peter StoevKeymaster]

Hi krunch,

The displayed results are the results after calling the JavaScript Array’s sort method. I don’t know how it internally works and what it takes into account. I assume that it is case-sensitive.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[krunchParticipant]

Ok!

I have removed the sorting in the jqxinput.js code (line b = this.sort(b);)
It works, thanks !

[Peter StoevKeymaster]

Hi krunch,

Please, note that such modifications are prohibited as pointed out in the EULA, if you are not licensed user.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts