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

    Database Content Not Showing up in Editor

    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

    Re: Database Content Not Showing up in Editor

    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

    Re: Database Content Not Showing up in Editor

    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
View as RSS news feed in XML