format output from long field in Db

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default format output from long field in Db

    :confused;
    can anyone tell me how to format a very long database field when output it to
    page. everything works fine except it is one very long string and i'd like to
    make it into several paragraphs. is there a way to put some break in the Db or
    some nifty CF tag??
    grateful in advance for any help.

    firedreams50 Guest

  2. Similar Questions and Discussions

    1. VS2005 How to 'format' a long HTML Attribute
      Hi. I have a vs2005 custom web control. It uses a designer inherited from ControlDesigner. The designer writes an XML value as a string property...
    2. JPG stored as long binary in database: how to write output as image in asp?
      Hello, For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics. The benefit of the program is that it stores...
    3. output jpg stored in database as long binary to asp: how?
      Hello, For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics. The benefit of the program is that it stores...
    4. Updating a Long VarChar field
      Hi, I'm having problems to update a LONG VARCHAR field. Suppose I have a table with two fields (the key field named TheKey, and a long varchar...
    5. #15123 [Dup->Csd]: strtotime doesn't work with long date format
      ID: 15123 Updated by: sniper@php.net Reported By: htheking at gmx dot de -Status: Duplicate +Status: ...
  3. #2

    Default Re: format output from long field in Db

    Try putting <PRE> tags around it.

    <PRE>
    #LongText#
    </PRE>
    OldCFer Guest

  4. #3

    Default Re: format output from long field in Db

    :D
    thanks for the help!
    someone had told me i should have my longtext field be all one long unbroken
    line of text. but oyu're saying format it the way i want it to look on page and
    then use the <pre> ?

    firedreams50 Guest

  5. #4

    Default Re: format output from long field in Db

    You can add <br> (or any other html) to the string in the database.

    Also, beforeyou insert the text into the Db you could use:
    #Replace(long_text,chr(13),'<br>','ALL')#
    kyle969 Guest

Posting Permissions

  • You may not post new threads
  • You may 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