You are hitting a GET versus POST thing. GET has a limited size. Just switch to POST.
On Fri, Jan 4, 2013 at 10:21 AM, Darla Tande <[email protected]> wrote: > > 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:353763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
