Re: [jQuery] Is there have any JQuery plugin that can sort 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A?

2010-02-02 Thread aquaone 
Sort as in a tablesorter parser, an array, or what?

On Tue, Feb 2, 2010 at 07:37, HenryRock henryloke.myetr...@gmail.comwrote:

 I facing a problem in sorting :

 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A

 Sample data.

 I using the SQL to sort ASC but it return result as below:

 12A
 13A
 14A
 10A
 11A
 1A
 2A
 3A
 4A
 5A
 6A
 7A
 8A
 9A

 May I know is there have any plugin that can sort the sample data
 above to 1A until 14A?

 Thanks...

Re: [jQuery] Is there have any JQuery plugin that can sort 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A?

2010-02-02 Thread Randall Morgan 
Hi,

I'm not sure what DBMS you are using but most can sort many ways. You
may want to read your DBMS manuals and look for a natural sort method.
MySQL uses something like ORDER BY column_name NATURAL ASC or ORDER
BY column_name NATURAL DESC. Somewhere on the net should be an old
thread about sorting mixed numbers and alpha characters in MySQL. Try
Googling the topic. If the DB can handle the sort for you, you'll save
time and network traffic. Unless you really need to be able to sort
this on the client side.

Hope this helps

Randy

On Tue, Feb 2, 2010 at 8:37 AM, HenryRock henryloke.myetr...@gmail.com wrote:
 I facing a problem in sorting :

 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A

 Sample data.

 I using the SQL to sort ASC but it return result as below:

 12A
 13A
 14A
 10A
 11A
 1A
 2A
 3A
 4A
 5A
 6A
 7A
 8A
 9A

 May I know is there have any plugin that can sort the sample data
 above to 1A until 14A?

 Thanks...




-- 
If you ask me if it can be done. The answer is YES, it can always be
done. The correct questions however are... What will it cost, and how
long will it take?