ANY IDEAS ON SYNTAX OR WHAT I AM OVERLOOKING:
The problem is using CFQUERY update to post edited results extracted from a
memo field back to that memo field. TPLT_TXT is a memo field.
I can SELECT data and display in in a textarea fine. It bombs when I try to
put it back. There is data in the FORM.TPLT_TXT variable because I can
CFOUTPUT it to the screen directly before the update code.
Take the "TPLT_TXT" line of code out and it works fine -- put it back in
and I get the ODBC error Code = 37000
<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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
