Professional Web Applications Themes

Selecting fixed amount of characters from a "memo" fieldin an access database - Coldfusion Database Access

How would I do this? I don't care but preferably I would like to accomplish this IN the query. But probably it will have to be done after the data has come back. In that case, I would like to have a "..." placed after those 100 characters, is it possible? If so, how do I do it? Thanks Thanks, Tom...

  1. #1

    Default Selecting fixed amount of characters from a "memo" fieldin an access database

    How would I do this? I don't care but preferably I would like to accomplish
    this IN the query. But probably it will have to be done after the data has
    come back. In that case, I would like to have a "..." placed after those 100
    characters, is it possible? If so, how do I do it?

    Thanks Thanks,
    Tom

    Tomdogggg Guest

  2. #2

    Default Re: Selecting fixed amount of characters from a "memo"field in an access database

    I'm pretty sure Access has a standard 'left' function like most databases...

    <cfquery...>
    select left(myMemoColumn, 100) as mySummary
    from...
    </cfquery>

    cf_montare Guest

  3. #3

    Default Re: Selecting fixed amount of characters from a "memo"field in an access database

    Thanks for the help, I'm only about 6 months into coldfusion developing. A lot
    of times, the biggest challenge is knowing when certain functions exist and
    when you have to try to figure it out on your own.

    Tomdogggg Guest

  4. #4

    Default Re: Selecting fixed amount of characters from a "memo" field inan access database

    If you have Access installed C:\Program Files\Microsoft
    Office\Office\1033\JETSQL40.CHM gives you the Access JetSQL reference
    The VB help comes in handy once in awhile as well!
    HTH
    --
    Tim Carley
    [url]www.recfusion.com[/url]
    [email]infoNOSPAMINGrecfusion.com[/email]
    Mountain Lover Guest

Similar Threads

  1. Acrobat 8 hangs when selecting "Help" menu...
    By kristin_maling@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 7
    Last Post: March 23rd, 12:39 PM
  2. Selecting multiple pages in Acrobat 7 "re-orders" them...
    By Marc_Hoffman@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 5
    Last Post: May 3rd, 10:14 PM
  3. access database connection please help ".net"
    By soulfood in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 7th, 06:38 PM
  4. Selecting a "region of interest" then building crops around this?
    By David John Morris in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 1
    Last Post: August 14th, 04:08 PM
  5. Crash when Selecting "Fill" or "Stroke"
    By N. Blake in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 0
    Last Post: July 5th, 08:13 PM

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