And plenty or sarcastic ones at that :-) It's because Dave doesn't actually do any work, he clearly spends all day on discussion lists LOL
On Sat, Sep 25, 2010 at 12:52 AM, Michael Grant <[email protected]> wrote: > > Meh. I'm keeping my Dave Watts shrine right where it is. He's a smart guy > that seems to have an answer to everything. > > (Well except my question about cfinvoke and webservices.) > /me walks away grumbling. > > On Fri, Sep 24, 2010 at 3:06 PM, Jacob Munson <[email protected]> wrote: > > > > > Wow, calm down there partner! I clearly stated in my post that I could > be > > wrong about this, and I invited people to correct me if I am wrong. > > > > As far as "Dave is of course correct as usual". Dave has been known to > be > > wrong before. Feel free to dismantle your Dave Watts shrine. ;) > > > > I KNOW for a fact that I read an article a couple of years ago that > > explained things the way I explained them earlier. I learned that using > > prepared statements causes CF to send a compiled (yes, compiled) chunk of > > code to SQL Server, lightening the DB's load. Also, I learned that > leaving > > pieces of your "search" (the right side of Where/And) out of the bind > would > > cause the whole thing to be sent as plain SQL instead of compiled. That > is > > NOT to say that the security benefits would break down, just the > > performance. > > > > AGAIN, I will say that I could be wrong here. But I will defend myself > and > > say that whoever wrote that article a couple of years ago was wrong...not > > me. > > > > On Fri, Sep 24, 2010 at 8:17 AM, Russ Michaels <[email protected]> > > wrote: > > > > > > > > It is a complex topic for many, and Dave is of course correct as usual. > > > It would be wise to a bit of research on the topic before giving out > > > incorrect advise and also for yourself to make sure you understand the > > > process correctly to aid in your own query design. > > > There is a lot of info regarding this on Microsofts SQL server MSDN and > > > technet pages. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
