CFQUERY UPDATE problem on FoxPro Memo fields

2000-12-03 Thread Arden Weiss
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

CFQUERY UPDATE problem on FoxPro Memo fields -- more info

2000-12-03 Thread Arden Weiss
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.

FW: CFQUERY UPDATE problem on FoxPro Memo fields -- more info

2000-12-03 Thread Arden Weiss
Solved problem -- I think. I added a hidden field on the data entry page per example code below and it worked. !- Apparently a TPLT_TXT hidden field required for textarea field to pass results to a CFQUERY update action on called page. --- INPUT TYPE="hidden" NAME="TPLT_TXT"