Populating rich text editor from database

[Sarah555]

Hi,

I have been requested to incorporate a rich text editor to allow a non profit group to be able to edit their website. I have looked everywhere on the web and have not been able to determine how to populate the rich text editor with information from the database. Any help would be greatly appreciated as I have been working on this for a while.

The code is as follows:

<%dim PageType
PageType = 2
'PageType = Request.Form(&quot;PageType&quot%>
<STYLE TYPE=&quot;text/css&quot;>
TABLE#tblCoolbar
{
background-color:threedface; padding:1px; color:menutext;
border-width:1px; border-style:solid;
border-color:threedhighlight threedshadow threedshadow threedhighlight;
}
.cbtn
{
height:18;
BORDER-LEFT: threedface 1px solid;
BORDER-RIGHT: threedface 1px solid;
BORDER-TOP: threedface 1px solid;
BORDER-BOTTOM: threedface 1px solid;
}
.txtbtn {font-family:tahoma; font-size:70%; color:menutext;}
</STYLE>

<script LANGUAGE=&quot;JavaScript&quot;>
function button_over(eButton)
{
eButton.style.backgroundColor = &quot;#B5BDD6&quot;;
eButton.style.borderColor = &quot;darkblue darkblue darkblue darkblue&quot;;
}
function button_out(eButton)
{
eButton.style.backgroundColor = &quot;threedface&quot;;
eButton.style.borderColor = &quot;threedface&quot;;
}
function button_down(eButton)
{
eButton.style.backgroundColor = &quot;#8494B5&quot;;
eButton.style.borderColor = &quot;darkblue darkblue darkblue darkblue&quot;;
}
function button_up(eButton)
{
eButton.style.backgroundColor = &quot;#B5BDD6&quot;;
eButton.style.borderColor = &quot;darkblue darkblue darkblue darkblue&quot;;
eButton = null;
}

//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
</SCRIPT>

<P><STRONG><FONT size=3>Online Content Editor</FONT></STRONG></P>
<form name=&quot;editor&quot; method=&quot;post&quot; action=&quot;submit_editor.asp&quot;>
<table id=&quot;tblCoolbar&quot; width=542 cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;>
<tr valign=&quot;middle&quot;>

<td colspan=16>
<select onchange=&quot;cmdExec('formatBlock',this[this.selectedIndex].value);this.selectedIndex=0&quot;>
<option selected>Style</option>
<option value=&quot;Normal&quot;>Normal</option>
<option value=&quot;Heading 1&quot;>Heading 1</option>
<option value=&quot;Heading 2&quot;>Heading 2</option>
<option value=&quot;Heading 3&quot;>Heading 3</option>
<option value=&quot;Heading 4&quot;>Heading 4</option>
<option value=&quot;Heading 5&quot;>Heading 5</option>
<option value=&quot;Address&quot;>Address</option>
<option value=&quot;Formatted&quot;>Formatted</option>
<option value=&quot;Definition Term&quot;>Definition Term</option>
</select>
<select onchange=&quot;cmdExec('fontname',this[this.selectedIndex].value);&quot;>
<option selected>Font</option>
<option value=&quot;Arial&quot;>Arial</option>
<option value=&quot;Arial Black&quot;>Arial Black</option>
<option value=&quot;Arial Narrow&quot;>Arial Narrow</option>
<option value=&quot;Comic Sans MS&quot;>Comic Sans MS</option>
<option value=&quot;Courier New&quot;>Courier New</option>
<option value=&quot;System&quot;>System</option>
<option value=&quot;Tahoma&quot;>Tahoma</option>
<option value=&quot;Times New Roman&quot;>Times New Roman</option>
<option value=&quot;Verdana&quot;>Verdana</option>
<option value=&quot;Wingdings&quot;>Wingdings</option>
</select>
<select onchange=&quot;cmdExec('fontsize',this[this.selectedIndex].value);&quot;>
<option selected>Size</option>
<option value=&quot;1&quot;>1</option>
<option value=&quot;2&quot;>2</option>
<option value=&quot;3&quot;>3</option>
<option value=&quot;4&quot;>4</option>
<option value=&quot;5&quot;>5</option>
<option value=&quot;6&quot;>6</option>
<option value=&quot;7&quot;>7</option>
<option value=&quot;8&quot;>8</option>
<option value=&quot;10&quot;>10</option>
<option value=&quot;12&quot;>12</option>
<option value=&quot;14&quot;>14</option>
</select>

</td>

</tr>
<tr>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('cut')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Cut.gif&quot; alt=&quot;Cut&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('copy')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Copy.gif&quot; alt=&quot;Copy&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('paste')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Paste.gif&quot; alt=&quot;Paste&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('bold')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Bold.gif&quot; alt=&quot;Bold&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('italic')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Italic.gif&quot; alt=&quot;Italic&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('underline')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Under.gif&quot; alt=&quot;Underline&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('justifyleft')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Left.gif&quot; alt=&quot;Justify Left&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('justifycenter')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Center.gif&quot; alt=&quot;Center&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('justifyright')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;1&quot; vspace=1 align=absmiddle src=&quot;images/Right.gif&quot; alt=&quot;Justify Right&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('insertorderedlist')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;2&quot; vspace=1 align=absmiddle src=&quot;images/numlist.GIF&quot; alt=&quot;Ordered List&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('insertunorderedlist')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;2&quot; vspace=1 align=absmiddle src=&quot;images/bullist.GIF&quot; alt=&quot;Unordered List&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('outdent')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;2&quot; vspace=1 align=absmiddle src=&quot;images/deindent.gif&quot; alt=&quot;Decrease Indent&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('indent')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;2&quot; vspace=1 align=absmiddle src=&quot;images/inindent.gif&quot; alt=&quot;Increase Indent&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;foreColor()&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;2&quot; vspace=1 align=absmiddle src=&quot;images/fgcolor.gif&quot; alt=&quot;Forecolor&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;cmdExec('createLink')&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;2&quot; vspace=1 align=absmiddle src=&quot;images/Link.gif&quot; alt=&quot;Link&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;insertImage()&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;2&quot; vspace=1 align=absmiddle src=&quot;images/Image.gif&quot; alt=&quot;Image&quot;>
</div></td>

<td><div class=&quot;cbtn&quot; onClick=&quot;Save()&quot; onmouseover=&quot;button_over(this);&quot; onmouseout=&quot;button_out(this);&quot; onmousedown=&quot;button_down(this);&quot; onmouseup=&quot;button_up(this);&quot;>
<img hspace=&quot;2&quot; vspace=1 align=left align=absmiddle src=&quot;images/Save.gif&quot; alt=&quot;Save&quot;>
<font class=txtbtn>Save&nbsp;&nbsp;</font>
</div></td>

<td width=200></td>

</tr>
</table>

<input name=&quot;bodytext&quot; type=&quot;hidden&quot; value=&quot;&quot;></form>
<iframe scr=&quot;

http://www33.brinkster.com/kidfury/Debug/getContent.asp?PageType=<%=PageType%>&quot;

width=&quot;542&quot; height=&quot;350&quot; id=&quot;idContent&quot; ></iframe>
<script LANGUAGE=&quot;JavaScript&quot;>
var isHTMLMode=false


function document.onreadystatechange()
{
idContent.document.designMode=&quot;On&quot;
}

function cmdExec(cmd,opt)
{
if (isHTMLMode){alert(&quot;Please uncheck 'Edit HTML'&quot;return;}
idContent.document.execCommand(cmd,&quot;&quot;,opt);idContent.focus();
}
function setMode(bMode)
{
var sTmp;
isHTMLMode = bMode;
if (isHTMLMode){sTmp=idContent.document.body.innerHTML;idContent.document.body.innerText=sTmp;}
else {sTmp=idContent.document.body.innerText;idContent.document.body.innerHTML=sTmp;}
idContent.focus();
}
function createLink()
{
if (isHTMLMode){alert(&quot;Please uncheck 'Edit HTML'&quot;return;}
cmdExec(&quot;CreateLink&quot;
}
function insertImage()
{
if (isHTMLMode){alert(&quot;Please uncheck 'Edit HTML'&quot;return;}
var sImgSrc=prompt(&quot;Insert Image File (You can use your local image file) : &quot;, &quot;

http://www.aspalliance.com/Yusuf/Article10/sample.jpg&quot;);

if(sImgSrc!=null) cmdExec(&quot;InsertImage&quot;,sImgSrc);
}
function Save()
{
if (isHTMLMode){alert(&quot;Please uncheck 'Edit HTML'&quot;return;}
var sImgTag = idContent.document.body.all.tags(&quot;IMG&quot;
var oImg;
for (var i = sImgTag.length - 1; i >= 0; i--)
{
oImg = sImgTag;
alert(&quot;Add your code to Upload local image file here. Image Inserted : &quot; + oImg.src );
}
document.editor.bodytext.value = idContent.document.body.innerHTML;
document.editor.submit()
alert(&quot;Your Document : &quot; + idContent.document.body.innerHTML);
}
function foreColor()
{
var arr = showModalDialog(&quot;selcolor.htm&quot;,&quot;&quot;,&quot;font-family:Verdana; font-size:12; dialogWidth:30em; dialogHeight:34em&quot; );
if (arr != null) cmdExec(&quot;ForeColor&quot;,arr);
}
</script>


<br>
<input type=&quot;checkbox&quot; onclick=&quot;setMode(this.checked)&quot;> Edit HTML


The code for getContents.asp is as follows:

<%
dim PageType
dim bodytext
dim conn
dim MdbFilePath

Set conn = Server.CreateObject(&quot;ADODB.Connection&quot
MdbFilePath = Server.MapPath(&quot;..\db\shci.mdb&quot
conn.Open &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & MdbFilePath & &quot;;&quot;


'Create the Connection object
'set conn = server.createobject(&quot;adodb.connection&quot
'conn.open strconn

'Create the recordset object
set rs = server.createobject(&quot;adodb.recordset&quot
'This statement opens the table so we can add a record notice the addnew
'The 2, 2 is how the table is opened there are many ways it can be opened
'rs.open &quot;CustOrder&quot;, conn, 2, 2
PageType = 2
'PageType = Request.QueryString(PageType)

If PageType = &quot;2&quot; Then
SQL = &quot;SELECT * FROM Welcome&quot;
Set rs = conn.Execute(SQL)
End If

bodytext = rs(&quot;bodytext&quot
Response.Write(bodytext)
rs.Close
Set rs = Nothing

conn.Close
Set conn = Nothing

%>

getContents.asp works fine. I am having a javascript error with the document.onreadystatechange() function - error missing ; before statement. And last but certainly not least for the life of me I can not figure out how to insert the contents of getContents.asp into the iframe. Thank-you in advance for any help.

 

[jammer1221]

Could you post a link to a test page or anything
Thanks
Jammer1221

 

[Sarah555]

The link would be

http://www33.brinkster.com/kidfury/Debug/proedit.asp

You can only use the editor in IE 5 or above but the JavaScript errors I have been debugging using Netscape 7.

If you need anything else please let me know. Thank-you.

Sarah