I ask in case of any performance reasons not to do so. I've left behind (previous project) an important tool/CFC that uses this "leave behind query" method in important areas. If I've made a faux pas in doing so, I'd like to know....
On 4/10/06, Andrew Mercer <[EMAIL PROTECTED]> wrote: > that is what I went with before the deleteRow functions came in > > > On 4/10/06, Barry Beattie <[EMAIL PROTECTED] > wrote: > > > > is there anything wrong with doing a query to leave behind what you don't > want? > > > > <cfquery dbtype="query" name="temp"> > > select * from origQofQ > > where not #condition#" > > </cfquery> > > > > <cfset origQofQ = temp /> > > > > > > > > On 4/6/06, Steve Onnis < [EMAIL PROTECTED]> wrote: > > > > > > Just my opinion, but that UDF is yuk. Imagine looping over a large > query > > > > > > -----Original Message----- > > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > Behalf > > > Of Dale Fraser > > > Sent: Friday, April 07, 2006 6:57 PM > > > To: cfaussie@googlegroups.com > > > Subject: [cfaussie] Re: query function to delete a row from a query > > > > > > > > > From cflib, cflib is your friend. > > > > > > <cfscript> > > > /** > > > * Removes rows from a query. > > > * Added var col = ""; > > > * No longer using Evaluate. Function is MUCH smaller now. > > > * > > > * @param Query Query to be modified > > > * @param Rows Either a number or a list of numbers > > > * @return This function returns a query. > > > * @author Raymond Camden ([EMAIL PROTECTED]) > > > * @version 2, October 11, 2001 > > > */ > > > function QueryDeleteRows(Query,Rows) { > > > var tmp = QueryNew(Query.ColumnList); > > > var i = 1; > > > var x = 1; > > > > > > for(i=1;i lte Query.recordCount ; i=i+1) { > > > if(not ListFind(Rows,i)) { > > > QueryAddRow(tmp,1); > > > for(x=1;x lte ListLen(tmp.ColumnList);x=x+1) { > > > QuerySetCell(tmp, > > > ListGetAt(tmp.ColumnList,x), query[ListGetAt(tmp.ColumnList,x)][i]); > > > } > > > } > > > } > > > return tmp; > > > } > > > </cfscript> > > > > > > > > > Regards > > > Dale Fraser > > > > > > > > > > -----Original Message----- > > > > From: cfaussie@googlegroups.com [mailto: [EMAIL PROTECTED] On > > > > Behalf Of Andrew Mercer > > > > Sent: Friday, 7 April 2006 17:54 PM > > > > To: cfaussie@googlegroups.com > > > > Subject: [cfaussie] Re: query function to delete a row from a query > > > > > > > > doesnt look like you can do a delete in QoQ > > > > > > > > > > > > > > > > > > > > On 4/7/06, Andrew Mercer <[EMAIL PROTECTED] > wrote: > > > > > > > > Does anyone know if there is something like queryDeleteRow() > {the > > > > opersite of queryAddRow()} in CF? > > > > google found this in a blueDragon file > > > > > > > > otherwise I guess i will have to do a QoQ to do it > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
