2 Replies Latest reply: Dec 20, 2011 10:52 AM by sakonnetweb RSS

    Memo field truncating on textarea form field

    sakonnetweb Community Member

      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