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.
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
WHERE queue_ID = #URL.queue_ID#
No luck as yet.....
Thanks for any solution to this.
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/WSc3ff6d0ea7785946117 2e0811cbf364104-7fe7.html
Note that you should also use CFQUERYPARAM in your SELECT query.
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!
Europe, Middle East and Africa