|
it
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
infinite hierarchy webpages
I am putting together a small CMS system and i need to use an infinite hierarchy for users to add unlimited pages, sub pages etc. I am really struggling to get the ASP to work. I have a single table for the pages 'tblsitepages' with a auto pk 'fldpageid', fldparentid, fldhierarchy, fldpagename the parentid starts at -1 for top level pages and would increment 2,3,4 etc for any subpages that have childpages fldhierarchy contains 0000.0000 and would increment depending on its parent. eg. page1 would be - fldpageid1 fldparentid -1 subpage1 - fldpageid4 fldparentid1 fldhierarchy 00001.00001 subpage2 - fldpageid5 fldparentid1 fldhierarchy 00001.00002 subsubpage1 - fldpageid6 fldparentid4 fldhierarchy 00001.00021 subsubpage2 - fldpageid7 fldparentid4 fldhierarchy 00001.00022 page2 would be - fldpageid2 fldparentid -1 page3 would be - fldpageid3 fldparentid -1 I hope this is making sense! I have the database built but I am struggling with the ASP Please can anyone help? Thanks! ...."I am struggling with the ASP" ...
What's your question ? Show quote <ro***@prodo.com> wrote in message news:c43bfd9e-5e09-4280-9ba5-938d3a9f9218@g30g2000hsb.googlegroups.com... > Hi All, > I am putting together a small CMS system and i need to use an infinite > hierarchy for users to add unlimited pages, sub pages etc. > > I am really struggling to get the ASP to work. > I have a single table for the pages 'tblsitepages' with a auto pk > 'fldpageid', fldparentid, fldhierarchy, fldpagename > > the parentid starts at -1 for top level pages and would increment > 2,3,4 etc for any subpages that have childpages > fldhierarchy contains 0000.0000 and would increment depending on its > parent. > > eg. > > page1 would be - fldpageid1 fldparentid -1 > subpage1 - fldpageid4 fldparentid1 fldhierarchy 00001.00001 > subpage2 - fldpageid5 fldparentid1 fldhierarchy 00001.00002 > subsubpage1 - fldpageid6 fldparentid4 fldhierarchy > 00001.00021 > subsubpage2 - fldpageid7 fldparentid4 fldhierarchy > 00001.00022 > > > page2 would be - fldpageid2 fldparentid -1 > page3 would be - fldpageid3 fldparentid -1 > > > I hope this is making sense! I have the database built but I am > struggling with the ASP > > Please can anyone help? > > Thanks! On Nov 28, 4:13 am, ro***@prodo.com wrote:
Show quote > Hi All, Sorry, I can do about anything in ASP, but I am not quite getting what> I am putting together a small CMS system and i need to use an infinite > hierarchy for users to add unlimited pages, sub pages etc. > > I am really struggling to get the ASP to work. > I have a single table for the pages 'tblsitepages' with a auto pk > 'fldpageid', fldparentid, fldhierarchy, fldpagename > > the parentid starts at -1 for top level pages and would increment > 2,3,4 etc for any subpages that have childpages > fldhierarchy contains 0000.0000 and would increment depending on its > parent. > > eg. > > page1 would be - fldpageid1 fldparentid -1 > subpage1 - fldpageid4 fldparentid1 fldhierarchy 00001.00001 > subpage2 - fldpageid5 fldparentid1 fldhierarchy 00001.00002 > subsubpage1 - fldpageid6 fldparentid4 fldhierarchy > 00001.00021 > subsubpage2 - fldpageid7 fldparentid4 fldhierarchy > 00001.00022 > > page2 would be - fldpageid2 fldparentid -1 > page3 would be - fldpageid3 fldparentid -1 > > I hope this is making sense! I have the database built but I am > struggling with the ASP > > Please can anyone help? > > Thanks! you are wanting done. You have a database that is holding a bunch of users pages, and each user can have any number pf pages. What from there? Not really.
Nothing to do with users specifically. Just trying to achieve a system where infinite pages/sub pages can be added by using one pages table. I tried to build a ASP version of the PHP 'cms made simple' but i cannot get it to work :-( Thanks wrote on 29 nov 2007 in microsoft.public.inetserver.asp.general:
> Not really. ?????????[please always quote on usenet] -- Evertjan. The Netherlands. (Please change the x'es to dots in my emailaddress) " i cannot get it to work :-( "
people can't help you with vague statements like the above . they can only help, if you post a specific problem, preferably with example code showing where the error occurs and a copy of the error message.  |
|||||||||||||||||||||||
Other interesting topics