Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Unanswered: Reading a Memo data type twice fails.

    Hello everybody

    I am using MS Access and ASP for a small website. In the database I have a few field which are of the type "Memo".

    When I read a field from a RecordSet, I can only do it once. The second time I read the field it is empty (""). Thus, I can only read the field once.

    The solution is to store the value in a variable, and then use this variable. However, I am more curious of why this problem occurs and how to fix it at RecordSet/Connection "level".

    Any suggestions?

  2. #2
    Join Date
    Nov 2002
    Posts
    2
    Found the answer, for anyone with the same problem, check out:

    http://www.aspfaq.com/show.asp?id=2188
    and
    http://support.microsoft.com/?kbid=200124

  3. #3
    Join Date
    Feb 2002
    Location
    North Wales, UK
    Posts
    114
    What version of IIS and MDAC are you running on your web server??
    J^ - web | email
    newsASP Developer

Posting Permissions

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