Adding new option to category menu, does not show up
6 posts by 2 authors in: Forums > CMS Builder
Last Post: September 7, 2010 (RSS)
By (Deleted User) - September 7, 2010
I have a category menu set up as follows:
RETAIL
- High Street
- Retail Warehousing
OFFICES
- City/Town Centre
- Business Park
INDUSTRIAL
- Office & Storage
- Factories
LAND
- Devlopment Land
- Sites
- Farms
HOTELS & BARS
- Pubs & Off Licences
- Restaurants & Takeaways
- Guest Houses, B&B's
- Hotels
INVESTMENTS
- Businesses
- Residential
I have added a new item at the end
INVESTMENTS
- Businesses
- Residential
- Artworks
My Properties table is set to take this list as Get Options from MySQL Query (Advanced), with the following:
SELECT num, breadcrumb
FROM `<?php echo $TABLE_PREFIX ?>property_types`
WHERE depth > 0
When I added the extra item, it does not show up as available to be chosen when adding or editing a property?
Agh!
Alan
Re: [AlanMacD] Adding new option to category menu, does not show up
By (Deleted User) - September 7, 2010
Home: Products: CMS Builder
ta
Re: [AlanMacD] Adding new option to category menu, does not show up
By Jason - September 7, 2010
I'll need to take a look at your CMS to try to figure out what's going on. If you could email your CMS login url and details to jason@interactivetools.com I can take a closer look.
Please only email this information, don't post it to the forum.
Thanks.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Adding new option to category menu, does not show up
By (Deleted User) - September 7, 2010
Alan
Re: [AlanMacD] Adding new option to category menu, does not show up
By Jason - September 7, 2010
I took a look at this issue for you. It looks that all of the children of the category "INVESTMENTS" were being displayed. The only issue is that the Artworks category was being displayed a couple of elements above businesses and residential. This could have been caused the artwork record being created out of order and then being moved. Regardless, I added an "ORDER BY" clause to your SQL statements so they will all be grouped together:
SELECT num, breadcrumb
FROM `<?php echo $TABLE_PREFIX ?>property_types`
WHERE depth > 0 ORDER BY parentNum ASCEverything seems to be displaying the way you would expect it to now. Take a look and let me know if you run into any other issues.
Hope this helps.
Jason
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Adding new option to category menu, does not show up
By (Deleted User) - September 7, 2010
facepalm
Thanks anyway !