A cfquery tag can potentially contain any number of SQL commands which may or may not return a result set. CF doesn't do any parsing of the SQL contained within, it just runs it. (The only exception being the SELECT, UPDATE, DELETE, DROP etc security set up in your datasource settings-- but that's not bullet proof)
Regardless, CF wouldn't know if the cfquery was going to return a result set until after it had sent the commands to the database for execution and waited for the results to come back, and that would sort of defeat the purpose, wouldn't it? ~Brad -------- Original Message -------- Subject: Re: What the heck is happening during CFQUERY? From: Claude Schneegans <schneeg...@internetique.com> Date: Mon, March 09, 2009 1:11 pm To: cf-talk <cf-talk@houseoffusion.com> >>(if CF were able to determine it was a select in the first place) Well, it must be able somehow to determine the query returns data, otherwise, how would it create a structure from any result set? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
