I am trying to update a Memo Field in Access XP using ASP. The main part
of the code that I am using is as follows:
<%
Dim objComm, noOfRecs, ID, TitleCopy, TextCopy
ID = Request.QueryString("ID")
TitleCopy = Request.Form("TitleCopy")
TextCopy = Request.Form("TextCopy")
Response.write (ID)
Response.write (TitleCopy)
Response.write (TextCopy)
Set objComm = Server.CreateObject("ADODB.Command")
objComm.ActiveConnection = strConnect
objComm.CommandText = "UPDATE CopyText Set Text = '" &
TitleCopy & "' Where ID = " & ID
objComm.CommandType = adCmdText
objComm.Execute
Set objComm = Nothing
%>
If I just change the Set Text bit to Set Title which is a Text Field in
the database then it will update it.
Thanks
Damien