Re: sql tables explanation?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Brett (anonymous_at_discussions.microsoft.com)
Date: 05/14/04

  • Next message: Bre59: "Linking to a Notes Database" 
    Date: Fri, 14 May 2004 12:31:06 -0700

    mzam,

    Thanks - essentially, the table I'll be looking for is UserData in the Portal's *_Site db. For others wondering, I see that when data is added the UserData and Lists tables are the pertinent information (in my case...). For example, I added my first Event for a site, and that added a row in the Lists table. The text of the even was added in the UserData table. The Lists.tp_id correlates to the UserData.tp_ListId. I see that the list created had a title (Lists.tp_Title) of "Events", etc...

    I am going to be creating a few web parts which will essentially act as the News or Events web parts do, where a person can add text and save to the database. Does anybody have a recommendation here? I feel like I should add this information in a separate database, so as not to tamper with the MSFT given ones. I'll need users to be able to add a "Did You Know" item to the company web site from the Portal site, where users will be able to modify / add them (like a content management piece).

  • Next message: Bre59: "Linking to a Notes Database"