Memo Type Field

Results 1 to 2 of 2

Thread: Memo Type Field

  1. #1
    Join Date
    Dec 1969

    Default Memo Type Field

    I am trying to simply update data in an Access2000 table with having field of type "Memo", my query is as follows:<BR><BR>sql = "update TravelPlan set Report=&#039;"&(request("Report"))&"&#039;, VisitPurpose=&#039;"&(request("VisitPurpose"))&"&# 039; where StaffCode=&#039;"&request("StaffCode")&"&#039; and LastVisit=&#039;"&request("LastVisit")&"&#039;" <BR><BR>but i&#039; m getting "Syntax Error". Can anybody please correct me.<BR><BR>Thanx<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Memo Type Field

    response.write your sql statement to the page to see what the actual statement looks like, it is possible that there is an illegal character in your memo field<BR><BR>mj

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts