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 -~----------~----~----~----~------~----~------~--~---