> 1) Is there really any advantage of not leaving it as Zero? Yes, usually it's better to have a higher number than zero here. You can't take advantage of connection pooling if the pool is set to zero.
> 2) It is just odd that we have two clients that both ran into > this on separate servers near the same time, when the code > has been working fine for years. One client is on CF8 and > the other on CF7. Is there something else that might be > causing this sudden problem? Did anything happen on your database servers? Are these applications using the same database server? > 3) What is your feeling on CFQueryParam? Do you use? Does it > help? If a query has it, then should all the variables in > the query use it? From my understanding, the code that uses > it was originally written to use CFQueryParam because we are > inserting large ammounts of text into a TEXT field. http://www.adobe.com/devnet/coldfusion/articles/cfqueryparam.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Server/message.cfm/messageid:6643 Subscription: http://www.houseoffusion.com/groups/CF-Server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
