Support forums - Database Content Not Showing up in Editor

Support forums » Products » Cute Editor for ASP » Database Content Not Showing up in Editor

Database Content Not Showing up in Editor

Last post 02-25-2010, 8:33 AM by bdassow. 2 replies.


	Sort Posts: Previous Next

02-24-2010, 11:00 AM 58947

bdassow
Joined on 02-24-2010
Posts 2

Database Content Not Showing up in Editor

Reply Quote

I am able to insert the content of the Editor into a database and view the content on a web page, but the database field ("text" fieldtype) content does not appear in the Editor when I read from the database. I currently have this in place to retrieve the data from the database and populate the Editor. How can I get the content to display within the editor?

I have looked at

http://cutesoft.net/asp/todatabase.asp but don't see an answer there.

Thanks

<% Dim editor
Set editor = New CuteEditor

editor.ID = "Editor1"
editor.Text = mfmNews

editor.ImageGalleryPath = "/editorUploads"
editor.MaxImageSize = 50
editor.AutoConfigure = "MFM_News"
editor.UseHTMLEntities = true

editor.Width = 530
editor.Height = 550
editor.Draw()
%>

02-25-2010, 7:54 AM 58972 in reply to 58947

Eric
Joined on 08-05-2009
Posts 1,269

Re: Database Content Not Showing up in Editor

Reply Quote

Dear bdassow,

In your code, editor.Text = mfmNews,editor will display the content of variable "mfmNews", when you query data from database , you should assign the retrieved result to variable "mfmNews", please check whether this step is correct.

Regards,

Eric

02-25-2010, 8:33 AM 58974 in reply to 58972

bdassow
Joined on 02-24-2010
Posts 2

Re: Database Content Not Showing up in Editor

Reply Quote

Eric,

This is what is declared in my file

sqlNews = "SELECT *, mfmNewsID FROM mfm_mfmNews WHERE (mfmNewsID = '" & mfmNewsID & "')"
set rsNews = conn.execute(sqlNews)

<% mfmNews = rsNews("mfmNDesc") %>

I have the same code in place on the webpage for public viewing.

http://ww2.mfmi.org/do/newsDetail.asp?mfmNewsID=1

Thanks for your support

Brad