Re: Updating info to existing pages

  •  10-22-2004, 4:58 PM

    Re: Updating info to existing pages

    So it this it??

     
     
     

    <%
     
              dim conn
              dim connstr
              Set conn = Server.CreateObject("ADODB.Connection")
              connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("test.mdb")
              conn.Open connstr
             
              dim content
             
    ID = Request("ID")
    If ID <> "" then
        sql="select TitleField,MessageField from test where id=" & Request.Querystring("id")
        'sql="select TitleField,MessageField from test where id="Request.Querystring("id")
        set rs=server.createobject("adodb.recordset")
        rs.open sql,conn,3,3         
        rs("TitleField") = TitleField
        rs("MessageField") = MessageField
        rs.update
        rs.Close
     response.write(request.querystring("id"))
        Set rs = nothing
    End If
     
          


    sql="select TitleField,MessageField from test where id=" & Cint(Request.Querystring("id"))

    set rs2=conn.execute(sql)
    if not rs2.eof then
        itleField = rs2("TitleField")
        MessageField = rs2("MessageField")
        rs2.close
        set rs2=nothing
    end if

      %>

     

     

     

                <%        
                
                 Dim editor
                 Set editor = New CuteEditor
        
                 editor.ID = "Editor1"
                 editor.Text = MessageField
                 editor.FilesPath = "editor_files"
                 editor.ImageGalleryPath = "/uploads"
                 editor.MaxImageSize = 50
                 editor.AutoConfigure = "fscc"
                 'editor.Template= "Bold,Italic,Underline"
                 'editor.StyleSheetPath = "/grey2.css"
                 editor.Width = 490
                 editor.Height = 300
                 editor.Draw()
      
                 ' Request.Form("Editor1_HTMLContent") access from other page
     
     %>
     
     
    COULD YOU PLEASE POST THE COMPLETE CODE ON HOW TO UPDATE/EDIT and HOW TO DISPLAY INFORMATION USING YOUR EDITOR.
     
    THAT WILL CONCLUDE OUR CORESPONDENCE ON THIS TOPIC OVER YOUR WEB SITE.

    Do you have an explanation on what your code does? Do you use purely ASP and SQL statements or do you also use VBScript? Is there anything else involved that I would need to learn in order to addapt your script to my needs?
     
View Complete Thread