Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asptoday_discuss thread: Updating a Memo Field in Access XP using ASP


Message #1 by mail@c... on Wed, 19 Jun 2002 12:42:46
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

  Return to Index