CodingForums.com - View Single Post - custom sidebars, has something to do with mapping?

Old Pedant · 10-26-2012, 08:31 PM

??? Will the sidebar be *PART* of the ASP.NET page or will it be an <iframe> and so semi-independent of the page?

If it is part of the page, why is there even a question? The category of the page is "shoes" so you simply use a SQL query that gets all subcategories of "shoes". If the category is "pants", you get subcategories of "pants".

All this means is that your DB design has to be correct, so that your SQL statement becomes

Code:

String SQL = "SELECT * FROM subcategories WHERE category = " + currentPageCategory;

(tha't's C#. VB.Net nearly identical)

10-26-2012, 08:31 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,200 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	??? Will the sidebar be PART of the ASP.NET page or will it be an <iframe> and so semi-independent of the page? If it is part of the page, why is there even a question? The category of the page is "shoes" so you simply use a SQL query that gets all subcategories of "shoes". If the category is "pants", you get subcategories of "pants". All this means is that your DB design has to be correct, so that your SQL statement becomes Code: String SQL = "SELECT * FROM subcategories WHERE category = " + currentPageCategory; (tha't's C#. VB.Net nearly identical) __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.