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

HI,

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

Darn - wrong forum - can a mod please move me to
Home: Products: CMS Builder
ta

Re: [Jason] Adding new option to category menu, does not show up

By (Deleted User) - September 7, 2010

Emailed details as requested :)

Alan

Re: [AlanMacD] Adding new option to category menu, does not show up

By Jason - September 7, 2010

Hi Alan,

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 ASC
Everything 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

D'oh so it was there all along?

facepalm

Thanks anyway !