yeah, This is an old thread, I thought of doing like this and I already created a QueryFactory but I have also given up this idea and now I am using simple nice CFQuery tag. QueryFactory looks nice and has lots of string manipulation things for query statements. This is one of the reason I droped the idea of using my queryFactory.
Buy you can log sql queries with sql profiler and SeeFusion. -Prashant On Sun, Jan 18, 2009 at 3:42 PM, Eric O'Connell <[email protected]>wrote: > 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. >>> >>> > > > > -- Prashant Roy http://www.aarambh.net/ http://hindipoems.co.in --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
