Re: CFqueryParam & Coldfusion 11
> The errors getting back are all "The request has exceeded the allowable time > limit Tag" What's happening on the database server? Have you stopped and restarted the database server? Have you disabled and reenabled the "Maintain Connections" option in your database driver? Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business (SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized instruction at our training centers, online, or onsite. ~| 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:359726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFqueryParam & Coldfusion 11
Does the line number on that error indicate that the query is what's timing out? On Fri, Nov 28, 2014 at 11:46 AM, Don wrote: > > The errors getting back are all "The request has exceeded the allowable > time limit Tag" > > Seems that the whole server eventually crashes/slows to crawl, even though > other websites on that same server are fine. > > CF Version 11 / SQL Server Express > > Looking at the JVM free memory, it always seems to be going down. not sure > what this points toany ideas? > > ~| 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:359725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFqueryParam & Coldfusion 11
The errors getting back are all "The request has exceeded the allowable time limit Tag" Seems that the whole server eventually crashes/slows to crawl, even though other websites on that same server are fine. CF Version 11 / SQL Server Express Looking at the JVM free memory, it always seems to be going down. not sure what this points toany ideas? ~| 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:359724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFqueryParam & Coldfusion 11
> Does anyone know of any supposed issues with CF 11 and cfqueryparam ? > > I had a few of them in a query. One by one I removed them to see if I could > get the > query working and then, adding them in. All but one work. > > Any ideas? You need to provide more information. Did the query work with CF 9 and CFQUERYPARAM? What is the error you're seeing, exactly? Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business (SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized instruction at our training centers, online, or onsite. ~| 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:359723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFqueryParam & Coldfusion 11
Were you getting an error? On Thu, Nov 27, 2014 at 3:08 AM, Don wrote: > > Does anyone know of any supposed issues with CF 11 and cfqueryparam ? > > I had a few of them in a query. One by one I removed them to see if I > could get the query working and then, adding them in. All but one work. > > Any ideas? > > > ~| 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:359718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFqueryParam & Coldfusion 11
Does anyone know of any supposed issues with CF 11 and cfqueryparam ? I had a few of them in a query. One by one I removed them to see if I could get the query working and then, adding them in. All but one work. Any ideas? ~| 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:359717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm