> > I'm not sure why everyone seems so hot about using trusted > > connections, > > maintain security via nt domain. fits in with other apps, > simplifies things a bit.
Yeah, but the primary benefit of being about to use trusted connections, at least in my mind, occurs when you already have a bunch of Windows users and you want to use their accounts as database logins. However, that doesn't usually happen with CF apps, even with CF 5 - if you use trusted connections there, you've got one account, the CF service account, and that's what gets used for all database connections. At that point, you might as well just create one native SQL account, I'd think. I suppose you could have used CFIMPERSONATE with CF 5 to log each user in with his own Windows login, but then you wouldn't be able to use all the nifty connection pooling stuff, which would hurt performance a bit I'm sure. > pre-mx, i could pile up a bunch of sql into 1 cfquery rather > than looping over a bunch of cfqueries. while you can still > do this in mx it seems as though there's quite a low limit > on the size/number of statements you can stuff in there. I haven't tested that at all, and it doesn't bother me much as long as I can still call my beloved stored procedures. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
