CFC/JSON problem saving long text fields
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
Re: CFC/JSON problem saving long text fields
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 da...@bis-net.net 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
Re: CFC/JSON problem saving long text fields
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 raymondcam...@gmail.comwrote: 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 da...@bis-net.net 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
Re: CFC/JSON problem saving long text fields
That did it! Thanks. ~| 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:353768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm