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:
<CFSET mLEN = LEN(RTRIM(#FORM.TPLT_TXT#))>
<CFSET mTEXT = LEFT(RTRIM(#FORM.TPLT_TXT#),mLEN)>
<CFQUERY NAME="DSP5_UP" DATASOURCE="COLAB2">
UPDATE TEMPLAT1
SET
TPLT_DES = '#FORM.TPLT_DES#' ,
TPLT_TXT = '#FORM.TPLT_TXT#' ,
L_EDIT_DT = '#FORM.L_EDIT_DT#' ,
EDIT_WHO = '#FORM.EDIT_WHO#'
WHERE TEMPLAT1.DIV_NUM = '#CLIENT.mDIV_NUM#'
AND TEMPLAT1.TPLT_FRM = '#FORM.TPLT_FRM#'
AND TEMPLAT1.TPLT_FLD = '#FORM.TPLT_FLD#'
AND TEMPLAT1.TPLT_NUM = '#FORM.TPLT_NUM#'
</CFQUERY>
Apparently there is a non-displaying character at the end of the string in
the textarea that the "LEN" function does not recognize; hence, the first
two commands strip it off and permit the UPDATE posting to occur.
I suppose that this is a design feature -- right?
What a goat rope! [:-(
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
