Happy New Year everyone,
I get a 404 error (in firebug) whenever I try to save a long text field to SQL
server. I have a CFWINDOW that opens to allow editing and a save button calls
the CFC. I separated out the description from the remainder of the record
trying to get this to work. I ended up working around this by splitting the
text into 500 char chunks and saving it that way. This solution is not working
well in production. So, I would like to find a way to do it without looping.
I've trapped the error on the javascript side and it just says 'undefined' for
the error's message. I added a simple insert query to the top of the CFC
function and that did not occur. So, the problem appears to be on the
javascript side.
Any ideas?
I have CF 9, SQL Server 2008, description is varchar(max)
Javascript call:
dataproxy.saveDescription(
frm.prdID.value,
frm.prdDescription.value
);
CFC Function:
<cffunction name="saveDescription">
<cfargument name="prdID" type="numeric" default="0">
<cfargument name="prdDesc" type="string" default="" >
<cfquery datasource="#THIS.dsn#">
UPDATE tblProducts
SET prdDescription=
<cfqueryparam cfsqltype="cf_sql_longvarchar"
value="#arguments.prdDesc#" >
WHERE prdID=
<cfqueryparam cfsqltype="cf_sql_int" value="#arguments.prdID#" />
</cfquery>
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353762
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
