FYI, it would have helped if I told you what to do. Just do this in your JS:
dataproxy.setHTTPMethod("post")
On Fri, Jan 4, 2013 at 10:35 AM, Raymond Camden <[email protected]>wrote:
> 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:353764
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
