Skip to main content
December 20, 2011
Answered

Memo field truncating on textarea form field

  • December 20, 2011
  • 1 reply
  • 2052 views

Greetings

I have a helpdesk app in which the user enters the issue on a form (memo field) and the tech enters their solution (another memo field).

I can't get the entire text that is in the DB to display on the tech's work form.

I tried: 

1) UPDATE main_helpdesk

  

       SET q_description = <cfqueryparam value="#Form.q_description#" cfsqltype="cf_sql_longvarchar" />

on the action page,

2) setting Unicode Compression to "no" in memo field properties in the DB (Access 2007 for now- SQLSever soon).

3) querying the memo fields separately from the main query:

SELECT queue_ID, q_description, q_tech_resolution

FROM main_helpdesk

WHERE queue_ID = #URL.queue_ID#

No luck as yet.....

Thanks for any solution to this.

sakonnetweb

This topic has been closed for replies.
Correct answer JR__Bob__Dobbs

Things to check.

1. Is the description value truncated in the database?  If so check the data type of the database column.

2. If the value is not truncated in the database, but is truncated in the SELECT query,  check that CLOB is enabled in your CF datasource.  See: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe7.html

Note that you should also use CFQUERYPARAM in your SELECT query.

1 reply

JR__Bob__DobbsCorrect answer
Inspiring
December 20, 2011

Things to check.

1. Is the description value truncated in the database?  If so check the data type of the database column.

2. If the value is not truncated in the database, but is truncated in the SELECT query,  check that CLOB is enabled in your CF datasource.  See: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe7.html

Note that you should also use CFQUERYPARAM in your SELECT query.

December 20, 2011

Wow- thanks. Works now….

Full text was always in DB, just getting truncated on the display page textarea box. Also increased buffer size in CF Admin for that DB's CLOB setting- thanks again!