Re: [4cdg] Editor Listing Page Sorting Issue
Hi,
You're correct, the reason the sort isn't working when clicking on a column is that the price field is being stored as text in the MySQL database.
To change this to a number value, go into your section editor and modify your price field. Under "Advanced Options" you'll see a option for "Mysql Column Type". Enter in the word "float" and hit save. You should now be able to sort those columns properly.
NOTE: Before doing this, it is ALWAYS a good idea to do a backup of your database in case anything goes wrong.
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/