Good questions. The data type of the field is (MS Access) Memo. The string is about
1400 characters. But I've been doodling around this morning with it, and I've gotten
it to take strings up to 2500 characters. The problem seems to be that I'm passing
some sort of carriage return that's mucking up my statement. If I could just find and
replace it, but I can't even figure out what the character is...
>>> [EMAIL PROTECTED] 6/1/01 8:51:54 AM >>>
what's the data type of the field objectcontent and exactly how long is your
string?
-----Original Message-----
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 15:40
To: CF-Talk
Subject: Re: Crazy Dynamic Update/FORM Structure question
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
