There have, from time to time, been CF'ers who shell out to Java to do their JDBC work if you find CFquery too limiting, heck you could get nested transactions as part of the deal.
speaking of old threads and old ideas: "FourQ is based on the theory that it only takes four database queries to provide a persistence layer for a component: select, insert, update and delete. At the very least these CFCs are a good learning tool for ColdFusion Component persistence and inheritence.." http://blog.daemon.com.au/archives/000087.html On Mon, Jan 19, 2009 at 10:07 AM, prashant roy <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
