CFQUERY UPDATE problem -- not solved

Thought I solved the problem, but not so... Worked fine when I updated the memo field with the TPLT_DES field that came from a text box. Bombs when I update the memo field with the contents of the textarea field. Hence ODBC works fine. Thus, the format or datatype or ??? of the textarea field

CFQUERY UPDATE problem -- not solved -- now solved.

Sorry to talk to myself about this problem, but, it's maddening. Apparently at least one solution is to trim the length of the string FORM.TPLT_TXT produced by the textarea to the length of the string in the textarea before doing the update (go figure) as follows: UPDATE TEMPLAT1 SET