| Author |
Message |
Bruno Sampaio
Guest
|
 Posted:
Thu Nov 03, 2005 5:51 pm Post subject:
CMS Database |
|
|
Hi!
On my CMS Site, there are news. Each new corresponds a new page based in a
template.
Can I read from CMS database these news? How can I?
I've saw the tables of database but didn't understand how I can read
contents from a specific channel.
Regards, |
|
| Back to top |
|
 |
Spencer Harbar [MVP]
Guest
|
| Posted:
Fri Nov 04, 2005 1:50 pm Post subject:
Re: CMS Database |
|
|
Direct access to the MCMS database (even for just reads) is unsupported.
You should use the Publishing API (PAPI) to retreive your postings and thier
placeholder content.
This is highly desirable as it insulates you from needing to understand the
schema, or how individual data items are linked (such as retrieving postings
in a channel).
For more information on the PAPI check out,
http://msdn.microsoft.com/library/en-us/MCMSSDK02/html/19feb2eb-f86c-4dc8-9be3-0965bb5a9417.asp?frame=true
hth
Spence
www.mcmsfaq.com
"Bruno Sampaio" <BrunoSampaio@discussions.microsoft.com> wrote in message
news:FA442388-E07B-47DD-8040-04236CD39AAC@microsoft.com...
| Quote: | Hi!
On my CMS Site, there are news. Each new corresponds a new page based in a
template.
Can I read from CMS database these news? How can I?
I've saw the tables of database but didn't understand how I can read
contents from a specific channel.
Regards, |
|
|
| Back to top |
|
|
Bruno Sampaio
Guest
|
| Posted:
Fri Nov 04, 2005 5:51 pm Post subject:
Re: CMS Database |
|
|
That's nice!
I didn't know the Publishing API.
Exists an article or document about the CMS Database? That explain the
tables, columns...
Thank you!
"Spencer Harbar [MVP]" wrote:
| Quote: | Direct access to the MCMS database (even for just reads) is unsupported.
You should use the Publishing API (PAPI) to retreive your postings and thier
placeholder content.
This is highly desirable as it insulates you from needing to understand the
schema, or how individual data items are linked (such as retrieving postings
in a channel).
For more information on the PAPI check out,
http://msdn.microsoft.com/library/en-us/MCMSSDK02/html/19feb2eb-f86c-4dc8-9be3-0965bb5a9417.asp?frame=true
hth
Spence
www.mcmsfaq.com
"Bruno Sampaio" <BrunoSampaio@discussions.microsoft.com> wrote in message
news:FA442388-E07B-47DD-8040-04236CD39AAC@microsoft.com...
Hi!
On my CMS Site, there are news. Each new corresponds a new page based in a
template.
Can I read from CMS database these news? How can I?
I've saw the tables of database but didn't understand how I can read
contents from a specific channel.
Regards,
|
|
|
| Back to top |
|
|
Stefan [MSFT]
Guest
|
| Posted:
Mon Nov 07, 2005 5:50 pm Post subject:
Re: CMS Database |
|
|
Hi Bruno,
never touch the database! The database schema is undocumented and can be
subject to change with any hotfix or service pack without notice.
In addition your application will break the Microsoft Support Boundaries for
MCMS if you access the database for read or write directly.
See here:
http://blogs.technet.com/stefan_gossner/archive/2005/03/16/396647.aspx
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
----------------------
"Bruno Sampaio" <BrunoSampaio@discussions.microsoft.com> wrote in message
news:706A1D8E-6654-4215-8D8A-30FEEF5BE790@microsoft.com...
| Quote: | That's nice!
I didn't know the Publishing API.
Exists an article or document about the CMS Database? That explain the
tables, columns...
Thank you!
"Spencer Harbar [MVP]" wrote:
Direct access to the MCMS database (even for just reads) is unsupported.
You should use the Publishing API (PAPI) to retreive your postings and
thier
placeholder content.
This is highly desirable as it insulates you from needing to understand
the
schema, or how individual data items are linked (such as retrieving
postings
in a channel).
For more information on the PAPI check out,
http://msdn.microsoft.com/library/en-us/MCMSSDK02/html/19feb2eb-f86c-4dc8-9be3-0965bb5a9417.asp?frame=true
hth
Spence
www.mcmsfaq.com
"Bruno Sampaio" <BrunoSampaio@discussions.microsoft.com> wrote in message
news:FA442388-E07B-47DD-8040-04236CD39AAC@microsoft.com...
Hi!
On my CMS Site, there are news. Each new corresponds a new page based
in a
template.
Can I read from CMS database these news? How can I?
I've saw the tables of database but didn't understand how I can read
contents from a specific channel.
Regards,
|
|
|
| Back to top |
|
|
Bruno Sampaio
Guest
|
| Posted:
Mon Nov 07, 2005 9:51 pm Post subject:
Re: CMS Database |
|
|
Thank you very much, Stefan!
I didn't find something about CMS database really.
I'm studying the PAPI and I think it will solve my problem.
Regards,
"Stefan [MSFT]" wrote:
| Quote: | Hi Bruno,
never touch the database! The database schema is undocumented and can be
subject to change with any hotfix or service pack without notice.
In addition your application will break the Microsoft Support Boundaries for
MCMS if you access the database for read or write directly.
See here:
http://blogs.technet.com/stefan_gossner/archive/2005/03/16/396647.aspx
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
----------------------
"Bruno Sampaio" <BrunoSampaio@discussions.microsoft.com> wrote in message
news:706A1D8E-6654-4215-8D8A-30FEEF5BE790@microsoft.com...
That's nice!
I didn't know the Publishing API.
Exists an article or document about the CMS Database? That explain the
tables, columns...
Thank you!
"Spencer Harbar [MVP]" wrote:
Direct access to the MCMS database (even for just reads) is unsupported.
You should use the Publishing API (PAPI) to retreive your postings and
thier
placeholder content.
This is highly desirable as it insulates you from needing to understand
the
schema, or how individual data items are linked (such as retrieving
postings
in a channel).
For more information on the PAPI check out,
http://msdn.microsoft.com/library/en-us/MCMSSDK02/html/19feb2eb-f86c-4dc8-9be3-0965bb5a9417.asp?frame=true
hth
Spence
www.mcmsfaq.com
"Bruno Sampaio" <BrunoSampaio@discussions.microsoft.com> wrote in message
news:FA442388-E07B-47DD-8040-04236CD39AAC@microsoft.com...
Hi!
On my CMS Site, there are news. Each new corresponds a new page based
in a
template.
Can I read from CMS database these news? How can I?
I've saw the tables of database but didn't understand how I can read
contents from a specific channel.
Regards,
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in