Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Thumbs up Unanswered: how to retrieve memo field from msaccess using asp

    i cannot retrieve the data field from msaccess(datatype is memo) using asp but all other fileds using various data types are displaying
    i change the memo datatype to text datatype its working fine.

    but i want it to be in memo b'cause the contents are large

    Anybody plz reply me quickly

    Waiting...................
    Last edited by vidyasagar_100; 02-27-04 at 05:43.

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    I think that memo datatype in MS Access is the same as TEXT datatype in MSSQL. So you need to move the field with memo datatype to the last position in your SELECT clause. Click the following link to review the details.

    http://www.dbforums.com/showthread.php?threadid=976872

  3. #3
    Join Date
    Feb 2004
    Posts
    5

    Thumbs up

    thank you for your help

    but since the memo field is not working,but when i change the memo field to text field(text capacity is max 255) its working.

    so ok,plz waiting for a another solution, i am also try from another side

  4. #4
    Join Date
    Dec 2003
    Posts
    454
    If you put the MEMO field at the last postion of your SELECT clause, it should be working.

  5. #5
    Join Date
    Feb 2004
    Posts
    5
    Thankyou Sir

    Its working fine............

Posting Permissions

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