Ok, I tried plugging the content into a test update statement that I knew was working.
Bombed out. Same error. There's either something in my text string that's causing a
failure, or access/ODBC won't accept that big of a string. Any thoughts on making it
do this?
Willy
>>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>>
Ok, I'm having some trouble here. I don't know what the form looks like, as it's
being generated dynamically. So, I figure, I'll have to loop through the FORM
structure, and run a seperate update for each form element.
Here's what I'm doing:
<cfloop collection="#form#" item="i">
<cfquery datasource="mydatasource">
UPDATE contentitems
SET objectcontent='#form["#i#"]#'
WHERE objectname='#i#'
AND page='#FORM.page#'
</cfquery>
</cfloop>
Now the first element of the loop it will hit will be a field from the form called
"Body." It's the first possibility, alphabetically. And value is going to be a
really long string of text. I've set "page" on the form earlier on.
It should come out like this:
UPDATE contentitems
SET objectcontent = 'great big long string of text...'
WHERE objectname = 'BODY'
AND page = '1'
And it does, but I get an error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query
expression "great big long string of text running out to a point at which it gets
truncat'
Then it shows my sql, and it really does look like I had hope it would...Am I just
missing something in my update statement?
Willy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
