Sitefinity Blogs

Little known Sitefinity configuration settings
More detailed examples for Sitefinity component usage
Work-arounds for Sitefinity limitations
Discoveries and Ah-Ha moments

How to change 'Show in navigation' property of a page with an SQL command

by Rich Winslow | Jul 06, 2010

We had a fixed html menu for a website and a hundred pages with the navigate attribute set true when we wanted to set 95% of them false.

The sf_CmsPageProps (Sitefinity page properties table) has a column called 'Navigable' that determines if a page shows in the Site Menu or not.

The following SQL command takes all pages out of the Site Menu control (so you can turn on the few that you want instead editing each page to turn the bulk of them off):

update sf_CmsPageProps set navigable = 0 WHERE (Navigable = 1)

4 Comments

1 nike free run 11 May
NIKE FREE prefers Nike Free 3.0 via a NIKE FREE RUN directory of about three prospects that is to be deliver to your ex NIKE SHOX by simply Mr Moreno’s bash, your left-of-centre Democratic Person of polish lineage. Few will certainly pass up Mr Moreno: entirely NIKE SKO 84% Nike Free dame in the city’s people Shox Nike got a bad impression involving ...
2 cheap jordans 03 May
kjhhgfgghh
3 jordan 3 02 May
ffff
4 cheap jordans 26 Apr
no such persons <a href="http://www.usjordanspizike.org/jordan-1-flight-C72.html">jordan 1 flight low</a> immigration records. <a href="http://www.usjordanspizike.org/">jordan spizike</a> Finally, the <a href="http://www.usjordanspizike.org/jordan-25th-anniversary-C71.html">jordan 25th anniversary collection</a> rescue shelter <a href="http://www.usjordanspizike.org/jordan-25th-anniversary-C71.html">jordan 11 25th anniversary</a> dedicated staff to send his <a href="http://www.usjordanspizike.org/air-jordan-retro-10-C41.html">air jordans 10</a> father to the Zhongshan <a href="http://www.usjordanspizike.org/jordan-25th-anniversary-C71.html">jordan 25th anniversary</a> Lu Teruo.

Comment

Your name Click to add
Email (optional) Click to add
Website (optional) Click to add

Comment

Why Give Our Secrets Away?

I often get asked why I'm willing to journal all of my Sitefinity discoveries. People think I'm insane to give away for free what I labored over at some point.

Let me answer that in 2 parts:

Why journal my discoveries?

Because I forget and I want to a library of knowledge to refer back to. Oh but it is far worse than that... THREE TIMES now, I've gone to Google and searched for a solution to a problem, only to find MY OWN BLOG entry is #1 in Google and viola! there's the solution!
Why give it away for free?

Because others have been kind enough to do it for us; what goes around, comes around.

There are all levels of experience, thus someone with less experience may defer to us when needed.

The lines of 'competition' are very much blurred; in our minds competition is a potential customer or partnership in the right situation.

We maintain healthy partnerships with one of our competitors; they come to us when they need help and visa versa.

There is plenty of work out there for everyone if you are putting out quality work and you are straightforward with clients and competition.

Talk to us about how we can help YOU!

Drop us an email
Give us a call: 828-862-6667 x300

Don't miss out!

Keep up with our Sitefinity discoveries!
Click on the RSS feed icon below or sign up for our newsletter.

Email Address: