I've spent a good part of my weekend trying to implement a code that will upload information from your CuteEditor to the database.

 

I've created a separate HTML page, that has a link that passes an ID value to my todatabase.asp page (example - todatabase.asp?ID=3)

 

Right now there is a code that goes throuugh the records and creates a new one at the end of the list:

 

           rs.addnew
           rs("TitleField") = TitleField
           rs("MessageField") = MessageField
           rs.update

 

I need that to be updating the row that I passed an ID for, and not create a new record.

 

Finally what is the easiest way to display a single page (a row) without giving anyone permissions to change them (to display that page).I would like to use ID pass, just a s above.

 

Please help me ASAP!

 

Thank you

 

Here is the Code:

 

ID = Request("ID")

End If

 

 

 

  if request("action")="save" then
           TitleField  = Request.Form("TitleField")
           MessageField = Request.Form("Editor1_HTMLContent")      
           
           sql="select TitleField,MessageField from test"
           set rs=server.createobject("adodb.recordset")
           rs.open sql,conn,3,3
           
           rs.addnew
           rs("TitleField") = TitleField
           rs("MessageField") = MessageField
           rs.update
           
           response.write "<font size=5 color=red>Kari, your message has been added</font>"
           response.write "<br>"
           rs.close
           set rs = nothing
          else
           MySQL="select top 1 * from test order by id DESC"
           set rs2=conn.execute(MySQL)
           if not rs2.eof then
            TitleField  = rs2("TitleField")
            MessageField  = rs2("MessageField")
            rs2.close
            set rs2=nothing
           end if
          end if 

 

It keeps on doing the same, and when  I replace it with the line you said I should, it gives me an error:

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'id='.

/text_edit/todatabase.asp, line 47

 

Not everyone wants to have a FORUM like application.

The true power of this app should be the ability to update the already created web pages.  I think this would really be beneficial for all.

 

Please, if you could, could you email the complete code from your submissions to bnmiros@yahoo.com.  I would really like to be able to do what you are saying is posible with updating existing pages. I've tried emailing you, but it wouldn't let me submit it over the forum.

I would really appreciate it.

 

Thank you Adam