ASP - infinite hierarchy webpages

Author

infinite hierarchy webpages

roger@prodo.com

2007-11-28, 7:56 am

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!

Jon Paal [MSMD]

2007-11-28, 6:56 pm

...."I am struggling with the ASP" ...

What's your question ?

<roger@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!

Brynn

2007-11-28, 6:56 pm

On Nov 28, 4:13 am, ro...@prodo.com wrote:
> 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!

Sorry, I can do about anything in ASP, but I am not quite getting what
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?

roger@prodo.com

2007-11-29, 3:56 am

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

Evertjan.

2007-11-29, 3:56 am

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)

Jon Paal [MSMD]

2007-11-29, 6:56 pm

" 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.

roger@prodo.com

2007-11-30, 7:56 am

On Nov 29, 5:38 pm, "Jon Paal [MSMD]" <Jon nospam Paal @ everywhere
dot com> wrote:
> " 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.

Apologies. I have built the database for my CMS with a sitepages table
that includes the the fields:

'fldpageid', fldparentid, fldhierarchy, fldpagename

My idea is to allow a site administrator to add infinite pages and sub
pages to the site.
My thinking was that if a page is added, (and i'll use the field names
above in order), that i could add any sub page to any page even the
page i was using as a parent page was itself a sub page. eg -

pageid="1", fldparentid="-1", fldhierarchy"", fldpagename"page1"

> pageid="2", fldparentid="1", fldhierarchy"1", fldpagename"subpage1"

[color=darkred]
> pageid="4", fldparentid="1", fldhierarchy"2", fldpagename"subpage2"

pageid="5", fldparentid="-1", fldhierarchy"", fldpagename"page2"

I am unsure if my method will work and need to know what ASP to write
in order to display the navigation correctly on page

Jon Paal [MSMD]

2007-11-30, 6:56 pm

looks like you are trying to create a breadcrumbs navigation display.

google this for ASP code examples :

asp -.net breadcrumbs

<roger@prodo.com> wrote in message news:36194a7f-96fa-422e-a9f5-838ed605f3d9@r60g2000hsc.googlegroups.com...
> On Nov 29, 5:38 pm, "Jon Paal [MSMD]" <Jon nospam Paal @ everywhere
> dot com> wrote:
>
> Apologies. I have built the database for my CMS with a sitepages table
> that includes the the fields:
>
> 'fldpageid', fldparentid, fldhierarchy, fldpagename
>
> My idea is to allow a site administrator to add infinite pages and sub
> pages to the site.
> My thinking was that if a page is added, (and i'll use the field names
> above in order), that i could add any sub page to any page even the
> page i was using as a parent page was itself a sub page. eg -
>
> pageid="1", fldparentid="-1", fldhierarchy"", fldpagename"page1"
>
>
>
>
> pageid="5", fldparentid="-1", fldhierarchy"", fldpagename"page2"
>
>
> I am unsure if my method will work and need to know what ASP to write
> in order to display the navigation correctly on page
>

Sponsored Links