Re: How to store the HTML code into database(microsoft access)

  •  07-25-2008, 2:40 AM

    Re: How to store the HTML code into database(microsoft access)

    Thank for help.
    i try to copy your coding to inside but show out the error is below
     
    Error Type:
    ADODB.Recordset (0x800A0CB3)
    Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
    /prototype/CuteEditor2/default.asp, line 14


    Browser Type:
    Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Avant Browser; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 2.0.50215)

    Page:
    POST 62 bytes to /prototype/CuteEditor2/default.asp

    POST Data:
    HTML_CONTENT=123%0D%0A&HTML_CONTENT%24ClientState=&action=true
     
    Set rs_page = Server.CreateObject("ADODB.Recordset")
                rs_page.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database/dbmemo.mdb")
                rs_page.Source = "Select top 1 * from tblmemo; "
                rs_page.CursorType = 3
                rs_page.CursorLocation = 2
                rs_page.LockType = 1
                rs_page.Open()
                    
                rs_page.addNew    <<line 14
                   rs_page("memo") = Request.Form("editor1") 
                rs_page.update    
                
                rs_page.close    
          Set rs_page = nothing
     
     
    Sorry i never learn asp or programing before. just wan install cute editor in my web.

View Complete Thread