> I should have been more specific. SQL is case sensitive if > the collation > is case sensitive, which I believe to be the case for ColdFusion > (although not explicitly defined). > In that light, it is not a bug to be fixed.
Jochem, I agreee that this is not a bug, but at least a dubious behaviour, don't you think? If CF follow the rules from a specific database (collation settings, specific sintax usage, case insensitive or sensitive, etc) it should do (as a natural consequence) the same in a query of query's, isn't? Not sure, maybe the fact that CFServer stores and deal with query's data "inside itsef" when using query of query's is the reason for this change in the behaviour. Since query of query's feature is used to improve data manipulation I believe CF should behave exactly the same when dealing with regular queries and query of query's. []'s Alex ::::| alex hübner ::::| [EMAIL PROTECTED] ::::| www.cfgigolo.com ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists