Now that the trim solution works -- well ah at least for cases where the
saved string is 256 characters long or less, CFQUESRY update now blows on
trimmed strings longer than 256 characters.
In CF Admin I have the Visual FoxPro Driver settings as "Free Table
Directory" and Long Text Buffer Size at 32,000 characters (probably only
applies to CFQUERY select ??).
The CFQUERY select part of the program retrieves a long string from the DBF
memo field and displays it in the textarea just fine. But unless I edit
the size to 256 characters or less the ODBC update blows with error message
37000.
Please -- any and all suggestions/ideas on what settings are needed to
overcome this 256 character limit...
Thanks in advance...
Arden Weiss
410-757-3487
-----Original Message-----
From: Arden Weiss [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, December 03, 2000 8:44 PM
To: '[EMAIL PROTECTED]'
Subject: 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:
<CFSET mLEN = LEN(RTRIM(ltrim(#FORM.TPLT_TXT#)))>
<CFSET mTEXT = LEFT(RTRIM(ltrim(#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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
