Select items sort by default

[kkaiser1952]

Description

Items in the select list will sort alphabetically instead of being listed in order of submission.

how to reproduce

$(".editable_selectTFC").editable("save.php", { 	// traffic
	    data    : '{"":"","Routine":"Routine","Welfare":"Welfare","Priority":"Priority","Emergency":"Emergency","Question":"Question","Sent":"Sent"}',
	    type    : "select",
	    tooltip : "Traffic dropdown",
	    style   : "inherit"
	 	});

expected result

Sort by input order as seen above.

actual result

Sort starts at Emergency and progress' alphabetically

Environment

Browser: All
OS: All

[NicolasCARPi]

So as I told you by email, this is actually a feature not a bug, but an option to control this behavior should exist.

[kkaiser1952]

Did I screw up? I’m so sorry. This was the first time I ever used Github. You’re right I should have asked for it as an option.

…

On May 31, 2018, at 9:16 AM, Nicolas CARPi ***@***.***> wrote: So as I told you by email, this is actually a feature not a bug, but an option to control this behavior should exist. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#176 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADRUHB1Ah86ySNVvX7hemg_6o2N5o_YPks5t3_sugaJpZM4UVHyD>.

[NicolasCARPi]

It's fine don't worry ;)

[NicolasCARPi]

Fixed in 2.0.5.

[kkaiser1952]

Hi Nicolas, I’m having an issue with one of my edits. I have a field for comments, they may contain any kind of character. But in testing the only one that seems to be causing me issues is a single quote mark ( ‘ ). Anytime it appears in the text entered into the field it just wipes out the field and does not process the request. I’ve tried mysql_real_escape_string() and other similar routines but none of them help. Truth is I don’t know if the problem is occurring in javascript or in PHP, all I know for sure is the text is not being entered into the field. Below is my code for the field, can you give me a place to start on solving this issue? $(".editC").editable("save.php", { // comments type : "text", placement : "top", placeholder: "", indicator : "Saving...", tooltip : "Comments Click to edit...", style : "inherit" }); Thanks Keith.

[NicolasCARPi]

Hello,

1. Which version of PHP are you running? Do you know about PDO and prepared statements?

2. It's probably an error in your PHP code, otherwise it would be reproducible on the demo.

[kkaiser1952]

I use PDO prepared statements. In further study of the problem, I found I could enter a ‘ (I call it a tick) into the DB direct without any issues using phpMYAdmin. So I went back to the PHP I used to write to the DB and by using this; $value = str_replace("'", "\'", $value); The procedure works and correctly writes to both tables in my DB. However the display on screen still shows the ‘ \ ‘ and therefore looks like this example on screen Keith\’s . That would seem to indicate I need to do a string replace to escape the tick on the javascript side as well. But I’m not sure where to do that, the only javascript is the code I sent you, below. $(".editC").editable("save.php", { // comments type : "text", placement : "top", placeholder: "", indicator : "Saving...", tooltip : "Comments Click to edit...", style : "inherit" });

…

On Aug 22, 2018, at 1:44 PM, Nicolas CARPi ***@***.***> wrote: Hello, Which version of PHP are you running? Do you know about PDO and prepared statements? It's probably an error in your PHP code, otherwise it would be reproducible on the demo. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#176 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADRUHDm9fTeTbTOVjXn1BKrjycrJQA9Oks5uTaaXgaJpZM4UVHyD>.

[NicolasCARPi]

Yes you can modify the JS (see callback function), but imho you should concentrate on fixing the ' issue you have with php. There should be no need for str_replace.

[kkaiser1952]

OK, I trust your. I’ll go look at the PHP and see if I can find the problem. Thanks...

…

On Aug 23, 2018, at 3:32 AM, Nicolas CARPi ***@***.***> wrote: Yes you can modify the JS (see callback function), but imho you should concentrate on fixing the ' issue you have with php. There should be no need for str_replace. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#176 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADRUHGmwNqxwoD_DEkYl4JYvfOnoPofMks5uTmiMgaJpZM4UVHyD>.