I realize this is an old thread, but I just had put in my $.02 :) One thing that I frequently find frustrating about <cfquery> is that it is not extensible. What if I want to log all of my database queries, and keep track of which ones are consistently underperforming? What if I need consistent error recovery (as mentioned above) from database accesses? With the opaque nature of <cfquery> there is just nothing you can do, and these are just a couple things that pop into mind.. Over my years of CF development this is a feature I've wished for again and again. It would be so bad if you could implement a custom tag that would have "output" scope by default:
<cf_myquery> select foo from bar where baaz = '#quux#' <!--- fails because you need to wrap this in <cfoutput> ---> </cf_myquery> Admittedly I've kind of given up on ever being able to do anything like this, but does anyone have any suggestions? I would really love to be able to wrap all my db queries in a timer and log those that take longer than, say, 100ms. Eric On Mon, Nov 17, 2008 at 10:15 AM, prashant roy <[email protected]>wrote: > you guys are right. Finally I decided to quit this Query Factory. thanks > for all suggestions. > > > On Mon, Nov 17, 2008 at 1:57 AM, Tom Chiverton < > [email protected]> wrote: > >> >> On Sunday 16 Nov 2008, prashant roy wrote: >> > 1. we are going towards object oriented concepts for our new >> application >> > <cfset querier = createObject( "QueryFactory" ) /> >> > <cfset querier.setDSN( "BSParty" ) /> >> > <cfset querier.setQueryString( "select * from table" ) /> >> > <cfset results = querier.execute() /> >> >> This doesn't seem good best practice to me. You'd normally have a >> 'BSParty' >> object with a method like 'getAll()', and it'd configure itself. >> >> > 3. trying to less CFQuery tags from all code and will make things >> shorter >> > something like this >> >> There is nothing wrong with CFQUERY. The key is to keep them out of your >> display code. >> >> -- >> Tom Chiverton >> >> >> >> **************************************************** >> >> This email is sent for and on behalf of Halliwells LLP. >> >> Halliwells LLP is a limited liability partnership registered in England >> and Wales under registered number OC307980 whose registered office address >> is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. >> A list of members is available for inspection at the registered office. Any >> reference to a partner in relation to Halliwells LLP means a member of >> Halliwells LLP. Regulated by The Solicitors Regulation Authority. >> >> CONFIDENTIALITY >> >> This email is intended only for the use of the addressee named above and >> may be confidential or legally privileged. If you are not the addressee you >> must not read it and must not use any information contained in nor copy it >> nor inform any person other than Halliwells LLP or the addressee of its >> existence or contents. If you have received this email in error please >> delete it and notify Halliwells LLP IT Department on 0870 365 2500. >> >> For more information about Halliwells LLP visit www.halliwells.com. >> >> >> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
