I'm trying to put together a dynamic web page help thingy, our web app
has many complex forms that each (nearly) need their own help page. I
was thinking of using a db to store the help text as HTML, referenced by
the Request.ServerVariables("SCRIPT_NAME"). So i've got this as my table:


CREATE TABLE tblPageHelp (
page_url varchar(100) NOT NULL,
lang char(5) NOT NULL, -- we have german + english speaking clients
page_title nvarchar(10) NOT NULL, -- <title> tag
page_hdg nvarchar(50) NOT NULL, -- e.g. <h1>
help_text nvarchar(3500) NOT NULL, -- max i can use
editByID nvarchar(255) NOT NULL, -- we use Windows NT user names,
which can be up to 255, not sure about unicode
editDT datetime NOT NULL

CONSTRAINT PK_tblPageHelp PRIMARY KEY (page_url, lang)
)


So to create the help text for the page the Admin has a small
icon/button on each and every page (include).

To view the page, I can use the same include which gets the
Request.ServerVariables("SCRIPT_NAME") and sends it to my help page with
the default language choice of the logged in user.

I can't see any big problems yet...

Additionally though, this may be similar to what we eventually use to
create all the text on the page in any language, well, the page_url and
lang code bits annyway. Can I de-normalise this table in any way? Should
I have a table just for the page_url and lang code?

Also I guess I'll have to use some sort of script to weed out <script>
and other tags when people are creating 'help_text', anyone know where
I can find this sort of thing?

Ben