Professional Web Applications Themes

Full Text display problem in MySQL Text column - Coldfusion Database Access

I'm having problems with CF MX 6.1 displaying any output from a database when I exceed about 4,500 characters in a MySQL database column. I'm not doing any funky joins, just a URL variable to select the row. I have a "bio" field and when that field exceeds more than 4500 characters, CF returns nothing from that row at all. (including other columns). The version of MySQL is 4.0.17, CF is MX 6.1. The same error occures in both the CMS I built using InterAKT's DW extensions (Nextensio and KTML) and in my basic detail page. Any idea's why this ...

Sponsored Links
  1. #1

    Default Full Text display problem in MySQL Text column

    I'm having problems with CF MX 6.1 displaying any output from a database when I
    exceed about 4,500 characters in a MySQL database column.

    I'm not doing any funky joins, just a URL variable to select the row. I have a
    "bio" field and when that field exceeds more than 4500 characters, CF returns
    nothing from that row at all. (including other columns).

    The version of MySQL is 4.0.17, CF is MX 6.1. The same error occures in both
    the CMS I built using InterAKT's DW extensions (Nextensio and KTML) and in my
    basic detail page.

    Any idea's why this is happening? Thanks for the help.

    btw, the site is www.goodstuffpr.com - the client's pages are the main
    culprit, although I've been able to duplicate the problem in the news section
    and press releases as well.
    And the CF code:

    <cfparam name="URL.col_id" default="1">
    <cfquery name="rsClients" datasource="goodstu_database">
    SELECT *
    FROM tbl_clients
    WHERE col_id =
    <cfqueryparam value="#URL.col_id#" cfsqltype="cf_sql_numeric">
    </cfquery>

    nothing special. the output is:
    <h1><cfoutput>#rsClients.col_name#</cfoutput></h1>
    <p><img src="../uploads/images/<cfoutput>#rsClients.col_image#</cfoutput>"
    alt="" class="floatLeft"
    /><cfoutput>#ParagraphFormat(rsClients.col_introTex t)#</cfoutput></p>
    <h2>Biography</h2>
    <cfoutput>#rsClients.col_bio#</cfoutput>


    Sponsored Links
    Clint_Ribble Guest

  2. #2

    Default Re: Full Text display problem in MySQL Text column

    > CF returns nothing from that row at all. (including other columns).
    What does rsClients.RecordCount contain when this happens?
    jdeline Guest

  3. #3

    Default Re: Full Text display problem in MySQL Text column

    What does it show in your ColdFusion Administrator DSN advanced settings for BLOB, CLOB, Long Text Buffer (chr), and Blob Buffer(bytes)?

    Phil
    paross1 Guest

Similar Threads

  1. mySQL and Full Text Search
    By Bill in forum MySQL
    Replies: 1
    Last Post: August 4th, 09:43 PM
  2. Replies: 0
    Last Post: June 14th, 12:29 PM
  3. [sfpug] Basic problem installing TSearch2 (full text
    By Josh Berkus in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: December 24th, 09:24 PM
  4. Basic problem installing TSearch2 (full text search)
    By Jon Asher in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: December 23rd, 06:34 AM
  5. need help with MySQL full text searching!!!!
    By Angelo Zanetti in forum PHP Development
    Replies: 4
    Last Post: July 22nd, 12:00 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