close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

dynamic menu changes

Thread began 11/30/2011 4:38 pm by bill3786 | Last modified 12/07/2011 10:40 am by Jason Byrnes | 1144 views | 10 replies |

bill3786

dynamic menu changes

Is there a simple way of temporarily or permanently removing a product category or subcategory from a dynamic menu. Is adding a productlive column to these two tables the way to do it?

Sign in to reply to this post

Jason ByrnesWebAssist

adding an active column to the table, setting it to a value of 1 or 0 then updating the recordsets that build the menu to only return records where the active column equals 1 will remove the category temporarily.

if you want to remove it permanently, delete the record from the table.

Sign in to reply to this post

bill3786

I've created the extra active columns in the productcategory and productsubcategory tables and realised that the dynamic menu wizzard seems to only allow one filter selection. I already have a GroupID filter in productcategory and a nested filter in productsubcategory as shown in the screenshot.

The only place I can see to add the extra WHERE for the active columns is in the recordsets for menu.php as shown in the screenshot.

Is this the only way to achieve this, if so what is the correct SQL to add after the existing WHERE?

Sign in to reply to this post

Jason ByrnesWebAssist

yes, that is the only way to add the extra filter.


the current where clause is:

WHERE Group=1

change that to:
WHERE Group=1 AND active=1

Sign in to reply to this post

bill3786

Thanks Jason, it all works fine now.

Sign in to reply to this post

bill3786

H Jason

I can temporarily switch off a category and subcategory individually as your instructions.
Is it possible when switching off a category to also automatically switch off the subcategory associated with it?

Sign in to reply to this post

bill3786

To clarify my earlier post, I have been successfull in switching off a category and its subcategory in the navbar navigation. My question was related to a dynamic search list (not the navbar) which I have added to the site.

Sign in to reply to this post

Jason ByrnesWebAssist

I'm not sure i follow what you mean, please provide more detail.

Sign in to reply to this post

bill3786

Ok, I've attached a screenshot which shows two dropdowns, one for category and the other for subcategory (still building site so not pretty yet).

If I switch off a category in the left dropdown the corresponding subcategory still shows in the right dropdown.

I would like the subcategory to disappear automatically when a category is switched off.

Hope this is clear.

Sign in to reply to this post

bill3786

My previous post still needs an answer but I've discovered another problem with the edited menu.php where I added the extra filter for the category and subcategory live columns.

Everything worked great until I made a subsequent change to the menu which caused the menu.php to be updated.

The new menu.php loses the previous manual edit for the live columns and I have to re-enter the original 8 extra filter statements.

Is there a way to keep these statements for all subsequent menu.php updates?

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...