Hi I have the Cute Editor installed in Dot Net Nuke. I have a SQl Server database tied to the app.

The problem I have is that it is not saving the text in it to the database.  But If I put data into the Database it does read that data.

I did some research on line and found any examples that weer similar had other issues in them that added several bits of complexity.

I'm sure my situation is easy but I'm new to using the editor so I'm hoping it is something I have missed or not sure what terms to search for.

 

Here is a snippet where I try to add the text of the editor to a parameter of a stored procedure that updates the data:

EditorImageOwner.Text = ds.Tables(0).Rows(0).Item("PortalSettingsDealerImageURL")

Please change:

 

 

to:

 

 .Parameters("@PortalSettingsDealerImageURL").Value = Server.HtmlDecode("Hello World")

 

Then try again.

 

If it is still not working, please post more code.

Hi.  Thanks for the reply.

 

Origional code:

 

result: both stored an empty string in the Database, overriding what was there before.

 

I have two editors and I made the changes as follows :

.Parameters("@PortalSettingsImageLogoURL").Value = Server.HtmlDecode("Hello World!")

.Parameters("@PortalSettingsDealerImageURL").Value = Server.HtmlDecode("Hello World!")

 

result: both saved the value "Hello World!" in the database

 

Now try:

 

 .Parameters("@PortalSettingsDealerImageURL").Value = Server.HtmlDecode("Hello World" & EditorImageOwner.Text))

 

If you get "Hello World" only, for some reasons, the Text property is empty when extracting the content from editor.

 

When debugging, you need to focus on this part.

 

Maybe you forget IsPostBack event, and set the editor value to empty automatically.

 

Public Sub Page_Load(sender As object, e As System.EventArgs)
 

Hi.

 

When I did the test above by appending "Hello World" to the text property I did get "hello World" in the database but nothing else.

 

I have figured out something however.  If I switch from the Rich Text Editor mode to the Basic Text Box mode before submission it does record the HTML to the database.  But I would like to not ask the USER to have to do that cause I know more then a few will submit without switching first and have an empty string pas through.

 

Here is my Page_Load  Sub:

 

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

            If Page.IsPostBack Then
                'Page is a postback
                updateDealerSettings() 'This is the Sub that fires the updates

                LabelStatusMessage.Text = "Updated at " & DateTime.Now
            Else
                'Page is not a postback
                populateDataFields() 'This Sub reads anything that may be in the database OK.

Woot!  I got it to work.

 

All I did was move the Sub call.

 

I took it out of the page_load event and put it in the button click event

 

        Protected Sub ButtonSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonSubmit.Click
            LabelStatusMessage.Text = "Updated at " & DateTime.Now
        End Sub

 

Thanks for all the guidance and time. :)