Skip to main content
A
Anonymous
June 20, 2008
Answered

CF Query limiting text

  • June 20, 2008
  • 1 reply
  • 279 views
I have a database that contains the content for the pages on my website. We're calling the in page_content using a fairly simple query but one of the pages truncates the amount of characters called in via the query.

It's in a MySQL db and the field is set to longtext and is all fine within there.

Is there any CF that needs to be changed to allow it to call in huge amounts of text?

Thanks in advance.
    This topic has been closed for replies.
    Correct answer
    It's been sorted, after a bit of googling it transpires that CF Administrator defaults to a character return of 64000 in longtext field.

    Changing the value in the Advanced Datasource Parameters to 120,000 allows the entire string to be returned.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    June 20, 2008
    If you cfdump the query, do you see all the text or is it truncated?
    A
    Anonymous
    June 20, 2008
    Dumping the query has the same result (a few hundred characters missing from the end of the string).
    The string is only returning 64000 characters, seems to be a limit set somewhere that caps it at this amount.

    I've double checked the DB and it's all there.
    A
    Anonymous
    Correct answer
    June 20, 2008
    It's been sorted, after a bit of googling it transpires that CF Administrator defaults to a character return of 64000 in longtext field.

    Changing the value in the Advanced Datasource Parameters to 120,000 allows the entire string to be returned.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices