ADDED INFO ON: ANY IDEAS ON SYNTAX OR WHAT I AM OVERLOOKING:
When I change the TPLT_TXT line so I'm just posting a text string "This is
some text" it works fine too. So the issue must have to with something I
need to do with the text string in the "textarea" field before running the
update. Thanks for any inputs...
<CFQUERY NAME="DSP5_UP" DATASOURCE="COLAB2">
UPDATE TEMPLAT1
SET
TPLT_DES = '#FORM.TPLT_DES#' ,
TPLT_TXT = 'This is some 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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
