| Author |
Message |
.Net Jeff
Guest
|
 Posted:
Thu Oct 13, 2005 4:51 pm Post subject:
Last Modified Date Keeps Changing. |
|
|
CmsHttpContext.Current.Posting.LastModifiedDate is reporting as today.
Does anyone know where this is coming from?
In the CMS database, there is 1 entry in ChangeTable with a
LastChangeTime of 2005-08-01.
In the Node Table the entry for this node has ModifiedWhen value of
2005-08-01.
So why is the API reporting a last modified date of 13 October?
(today).
We have an app which iterates through the postings and emails updated
postings to subscribers. It is sending this particular page out almost
every day (it might be everyday, but it has not been reported
everyday).
THanks
Jeff |
|
| Back to top |
|
 |
Stefan [MSFT]
Guest
|
| Posted:
Thu Oct 13, 2005 4:51 pm Post subject:
Re: Last Modified Date Keeps Changing. |
|
|
Hi Jeff,
first of all: stay out of the MCMS database.
Any direct access to the database breaks the support boundaries for MCMS.
About the last modified date: there are two objects in the database: the
posting object and the page object.
Both have a last modified date. I assume you looked at the wrong one.
The last modified date will change with any change of the posting. E.g. if
you replace an image in the resource gallery that is used on the posting or
if you update the posting through site deployment or if you change the start
or expiration date or if you sort the postings, ...
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------
".Net Jeff" <jeff@cumpsty.co.uk> wrote in message
news:1129212851.768339.264890@g43g2000cwa.googlegroups.com...
| Quote: | CmsHttpContext.Current.Posting.LastModifiedDate is reporting as today.
Does anyone know where this is coming from?
In the CMS database, there is 1 entry in ChangeTable with a
LastChangeTime of 2005-08-01.
In the Node Table the entry for this node has ModifiedWhen value of
2005-08-01.
So why is the API reporting a last modified date of 13 October?
(today).
We have an app which iterates through the postings and emails updated
postings to subscribers. It is sending this particular page out almost
every day (it might be everyday, but it has not been reported
everyday).
THanks
Jeff
|
|
|
| Back to top |
|
|
.Net Jeff
Guest
|
| Posted:
Mon Oct 17, 2005 12:50 am Post subject:
Re: Last Modified Date Keeps Changing. |
|
|
No offence but saying stay out of the MCMS database is a bit ridiculous
really. The CMS API is not the most efficient of beasts at best. One
(the only) benefit of CMS over other similar products is that it uses a
SQL database that can be queried directly.
If there is no support agreement in the first place, there is nothing
to break by querying the SQL database.
Also I have two processes, which deal with emai subscriptions to
postings. The process is slow and akward when written using the API,
but can be completed in a single stored procedure without.
As for my original problem...I was looking at the wrong database. I
was apparently looking at the database for the staging server, and not
the live server. The live server shows the correct information.
Cheers
Jeff |
|
| Back to top |
|
|
Stefan [MSFT]
Guest
|
| Posted:
Mon Oct 17, 2005 8:51 am Post subject:
Re: Last Modified Date Keeps Changing. |
|
|
Hi Jeff,
see here for details:
http://blogs.technet.com/stefan_gossner/archive/2005/03/16/396647.aspx
If you don't follow these rules you cannot expect to get support from
Microsoft.
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------
".Net Jeff" <jeff@cumpsty.co.uk> wrote in message
news:1129496832.828245.53740@g49g2000cwa.googlegroups.com...
| Quote: | No offence but saying stay out of the MCMS database is a bit ridiculous
really. The CMS API is not the most efficient of beasts at best. One
(the only) benefit of CMS over other similar products is that it uses a
SQL database that can be queried directly.
If there is no support agreement in the first place, there is nothing
to break by querying the SQL database.
Also I have two processes, which deal with emai subscriptions to
postings. The process is slow and akward when written using the API,
but can be completed in a single stored procedure without.
As for my original problem...I was looking at the wrong database. I
was apparently looking at the database for the staging server, and not
the live server. The live server shows the correct information.
Cheers
Jeff
|
|
|
| Back to top |
|
|
.Net Jeff
Guest
|
| Posted:
Wed Oct 19, 2005 12:51 pm Post subject:
Re: Last Modified Date Keeps Changing. |
|
|
OK you've sold me. I still think that there are occassions where the
database is a usefull tool for pulling out information that would
otherwise be unavailable.
....Ultimatly I don't like CMS. But 2 years ago my client made a
decision...and spent a lot of money.
Here's the problem...We have pages that are getting deployed despite
not being changed. I need to find out what has changed. normally I
would expect to edit the page and view the revision history, to compare
versions and see the differences.
The problem is that the live site has been installed as read only...so
I cant edit the site from the front end.
How can I view the revision history?
Cheers
Jeff
Stefan [MSFT] wrote:
| Quote: | Hi Jeff,
see here for details:
http://blogs.technet.com/stefan_gossner/archive/2005/03/16/396647.aspx
If you don't follow these rules you cannot expect to get support from
Microsoft.
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------
".Net Jeff" <jeff@cumpsty.co.uk> wrote in message
news:1129496832.828245.53740@g49g2000cwa.googlegroups.com...
No offence but saying stay out of the MCMS database is a bit ridiculous
really. The CMS API is not the most efficient of beasts at best. One
(the only) benefit of CMS over other similar products is that it uses a
SQL database that can be queried directly.
If there is no support agreement in the first place, there is nothing
to break by querying the SQL database.
Also I have two processes, which deal with emai subscriptions to
postings. The process is slow and akward when written using the API,
but can be completed in a single stored procedure without.
As for my original problem...I was looking at the wrong database. I
was apparently looking at the database for the staging server, and not
the live server. The live server shows the correct information.
Cheers
Jeff
|
|
|
| Back to top |
|
|
Stefan [MSFT]
Guest
|
| Posted:
Wed Oct 19, 2005 12:51 pm Post subject:
Re: Last Modified Date Keeps Changing. |
|
|
Hi Jeff,
the problem with the deployment will occur if resource gallery items which
are using in placeholders are deleted.
The delete action is a change which causes the posting to become marked for
deployment.
As the resource is marked as deleted it cannot be included in the SDO
package which means that the posting is deployed again and again till the
reference to the deleted resource is removed from the placeholder.
The revision history can only be viewed on a read-write site. You could
connect a second server (e.g. your development server) to the same database.
But as indicated: the problem is on the exporting database - which should be
read-write anyway.
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------
".Net Jeff" <jeff@cumpsty.co.uk> wrote in message
news:1129709880.934346.207250@o13g2000cwo.googlegroups.com...
| Quote: | OK you've sold me. I still think that there are occassions where the
database is a usefull tool for pulling out information that would
otherwise be unavailable.
...Ultimatly I don't like CMS. But 2 years ago my client made a
decision...and spent a lot of money.
Here's the problem...We have pages that are getting deployed despite
not being changed. I need to find out what has changed. normally I
would expect to edit the page and view the revision history, to compare
versions and see the differences.
The problem is that the live site has been installed as read only...so
I cant edit the site from the front end.
How can I view the revision history?
Cheers
Jeff
Stefan [MSFT] wrote:
Hi Jeff,
see here for details:
http://blogs.technet.com/stefan_gossner/archive/2005/03/16/396647.aspx
If you don't follow these rules you cannot expect to get support from
Microsoft.
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no
rights
New to MCMS?
Check out this book: Building Websites Using MCMS:
http://tinyurl.com/6zj44
----------------------
".Net Jeff" <jeff@cumpsty.co.uk> wrote in message
news:1129496832.828245.53740@g49g2000cwa.googlegroups.com...
No offence but saying stay out of the MCMS database is a bit ridiculous
really. The CMS API is not the most efficient of beasts at best. One
(the only) benefit of CMS over other similar products is that it uses a
SQL database that can be queried directly.
If there is no support agreement in the first place, there is nothing
to break by querying the SQL database.
Also I have two processes, which deal with emai subscriptions to
postings. The process is slow and akward when written using the API,
but can be completed in a single stored procedure without.
As for my original problem...I was looking at the wrong database. I
was apparently looking at the database for the staging server, and not
the live server. The live server shows the correct information.
Cheers
Jeff
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in