Developer forum

Forum » Development » Page ID counter

Page ID counter

E-mail notifications
Martin Gammelholm
Reply
Posted on 10/09/2013 19:57:41

Hi,

Anybody know where the page ID is controlled from?
I'm developing a new website, which only have about 50 pages so far, and all of a sudden, all new page IDs start from ~1050 and up.

I've tried deleting new pages with high IDs, but DW keeps creating new pages with high IDs, so it must be controlled somewhere.
I've looked through the databases and globalsettings, without finding anything useful.

 

Regards,
Martin
 


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 10/09/2013 20:29:48
Reply

Hi Martin,

 

The Page table has an Identity set which means each new page gets a sequential number. Also, IDs are not reused so if you delete a page and create a new one, the new ID is 1 higher than the previously generated page ID.

 

If this happened "all of a sudden", it looks like somebody created pages and then deleted them again.

 

Hope this helps,

 

Imar

 
Martin Gammelholm
Posted on 10/09/2013 20:35:45
Reply

Hi Imar,

Thanks for your reply.

I know about the identity on the page ID, and this is something that is controlled by the SQL server then, which I cannot change I guess?
I'm working on a local solution, so nobody but me is working with the database.. strange
 

/Martin

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 10/09/2013 20:49:53
Reply

You can change it by recreating the table and setting the "seed" value (which is the starting ID) to a value higher than the highest current page ID. However, I would recommend against it. Page IDs are more or less "internal" and should be treated as irrelevant from your perspective. Why do you want to control the ID?


Imar

 

You must be logged in to post in the forum