> > Some of my frustrations with MySQL are: > > - Only 1 query per <cfquery> > > I happen to think that is a good thing :)
Sorry, I have to jump in here. I agree with this, it is a good thing. They don't allow multiple queries because to do so is a security risk. But I always laugh because whenever I bring this up, SQL Server guys invariably get on my case stating that there's no security problem, or that MySQL DOES allow this. A guy commenting on this blog post even tried to convince me the problem was in ColdFusion instead of PHP: http://techfeed.net/blog/index.cfm/2006/11/1/Joel-Spolsky-errors-about-S QL-injection ------------------------------------------------------------------------------ This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ============================================================================== "EMF <idahopower.com>" made the previous annotations. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
