format issues using UPDATE command in MSACCESS

  •  09-12-2005, 2:30 AM

    format issues using UPDATE command in MSACCESS

    If I create a new record using a form that includes the cute editor it works.  When I call that record the cuteeditor populates the information properly.  When I click 'update' the information passed in the string looks like the text below.
     
    #1P#2#1#8TR#6NG #7tyl#9="C#6L#6R: #0ff00ff"#2Thi#7 i#7 n#5t g#5#5d.#1/#8TR#6NG#2#1/P#2

    The above is the exact text updated in the record.  When I go to update again the above text is populatied in the cuteeditor area of the form. 

    In the update_click code I am declaring the editor as:
    Dim
    OrganizationDescription = Request.Form.Item("OrganizationDescription")

    Dim sqlString  = "UPDATE community_outreach SET OrganizationDescription = '" & OrganizationDescription & "' WHERE (crID = " & crID & ")"

    Any advice? Thanks for your help.
View Complete Thread