Ask a Question related to ASP Database, Design and Development.
ben h #1
Advice please - dynamic web page help
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 h Guest
I cannot make the XSL file create dynamic links properly. I wanted to link a dynamic field to another dynamic field. I can make this much happen,...
please can someone help me - im at the end of my tether! ive got an access db. Its got a list of words that is to be a menu system stored in it....
Hello I have an Access db table which contains a field called URL. I have previously <cfset display_url = #rsListHistory.URL#>. When I display...
Hoping to add a "generate your own web service" feature to my application. I have been searching MSDN and other places for an example of .NET code...
I'm setting up a dynamic site following the dreamweaver mx tutorial, and I am unable to get the test server working properly. I have my local site...