Professional Web Applications Themes

AccessL full text for memo? - ASP Database

Hi All, I am accessing a memo field with a line like this: <%=(pagesRs.Fields.Item("notes").Value)%> but I find the text is being cut off at 256 characters. Is there a special way to access a memo field? Any advice would be most appreciated! Rob :)...

  1. #1

    Default AccessL full text for memo?

    Hi All,

    I am accessing a memo field with a line like this:
    <%=(pagesRs.Fields.Item("notes").Value)%>
    but I find the text is being cut off at 256 characters. Is there a special
    way to access a memo field?

    Any advice would be most appreciated!

    Rob
    :)


    Robert Guest

  2. #2

    Default Re: AccessL full text for memo?

    Found an answer:
    Access (at least when accessed via ASP, VBScript, and probably any method)
    will truncate memo fields if the SELECT statement involves inner joins with
    GROUP BY fields.
    http://www.jdhodges.com/log/1321

    Ouch.

    Rob
    :)
     


    Robert Guest

  3. #3

    Default Re: AccessL full text for memo?

    http://www.aspfaq.com/2188

    (Not sure why you would return memo columns as part of a JOIN with a GROUP
    BY...)

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Robert Mark Bram" <none> wrote in message
    news:415a89ff$0$20127$optusnet.com.au... 


    Aaron Guest

  4. #4

    Default Re: AccessL full text for memo?

    Hi Aaron,
     

    It was DISTINCT that was destroying me.. but I refashioned my sql to use
    nested queries and overcame the problem!

    Rob
    :)


    Robert Guest

  5. #5

    Default Re: AccessL full text for memo?

    Hi Aaron,
     

    It was the use of DISTINCT that caught me actually. I got around it by
    nesting queries and avoiding DISTINCT.

    ROb
    :)


    Robert Guest

Similar Threads

  1. Submitted text cut off although Memo in MS Access
    By liglin1 in forum Macromedia ColdFusion
    Replies: 1
    Last Post: February 20th, 08:33 AM
  2. Saving long text in a memo field
    By Bob Barrows in forum ASP Database
    Replies: 1
    Last Post: February 16th, 01:02 PM
  3. Replies: 3
    Last Post: September 19th, 05:01 PM
  4. losing text in memo field when double-spacing
    By Jocelyn in forum Microsoft Access
    Replies: 1
    Last Post: July 23rd, 04:05 PM
  5. text replacement in a memo filed
    By Allen Browne in forum Microsoft Access
    Replies: 0
    Last Post: June 30th, 04:02 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139