Memo field truncating on textarea form field
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.
