Buy Now
Sign in

Order Read Data in CF6

cyberspyder , September 11 2019, 21:48
C
cyberspyder 38
September 11 2019, 21:48 #389173
I'm trying to order this read data by the title field but when I put in the order fields 'Location.title', 'title', or 'table_name.title' it either does nothing or makes the drop down that it auto fills become blank. Am I putting in the wrong format for order fields or is it something else?
healyhatman 8
September 12 2019, 21:43 #389182
You should give your form fields a useful name like "location_title" or something instead of "select58"
You're also supposed to provide TWO fields, not three.
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
C
cyberspyder 38
September 12 2019, 23:23 #389183
Thank you very much for the reply. I really appreciate your time and attention. I removed the extra field provided (published) and still - no sorting. I just need to order these alphabetically by title.
What do we type in where it says order fields? We have tried only the column name for that table, which is "title". We have tried the tablename.title, we have tried our dataset Location.title nothing works. Most of them break the form.
healyhatman 8
September 12 2019, 23:32 #389184
You need to include the direction too.
title/asc or title/desc
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
C
cyberspyder 38
September 13 2019, 15:41 #389193
The default for making an order field is Ascending so we left it there and the form does nothing to sort the dropdown. Here's a screenshot of the form and the backend section.
healyhatman 8
September 13 2019, 20:32 #389195
Sorry forgot dropdowns are automatically sorted by key. Dunno where in the code it makes it like that soz
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store