Memo field truncating on textarea form field

[Guest]

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

[JR__Bob__Dobbs · Accepted solution]

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.

[Guest]

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!