QueryofQueries isn't available in CF 4.51 :) On Tue, 9 Jul 2002, Ken Beard wrote:
> i would use Query of queries. > > select from #queryname# > WHERE recordid<>#excludeme# > > ken > > -----Original Message----- > From: Jamie Jackson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 09, 2002 2:42 PM > To: CF-Talk > Subject: Re: CF 4.51 and Delete query Row (td) > > > QueryDeleteRows() > http://www.cflib.org/udf.cfm?ID=11 > > .Though it repopulates a new query with a loop, so I don't know how > efficient it is. > > Jamie > > On Mon, 01 Jul 2002 18:41:45 -0400, in cf-talk you wrote: > > >It appears that the following does not work: > > > >Since a query is a Structure of mostly Arrays, I figure that I can use > >the column list to get a list of arrays in the query structure and use > >the ArrayDeleteAt Function to delete the associated element for the row. > > > >Anyone know how to delete a row from a query structure? > > > >Thanks, > >Troy > > > >Troy Simpson wrote: > > > >> All, > >> > >> I am utilizing a query structure and using query functions to add more > >> data to the structure. I'm able to add new rows to the query structure > >> and add new data, but how do I delete a row of data from the query > >> structure? > >> > >> Since a query is a Structure of mostly Arrays, I figure that I can use > >> the column list to get a list of arrays in the query structure and use > >> the ArrayDeleteAt Function to delete the associated element for the row. > >> > >> Is this the way to do this in CF 4.51? > >> > >> On a side note, is CF 5 or better have a better way to do this? > >> > >> Thanks, > >> Troy > >> > >> -- > >> ------------------------- > >> Troy Simpson > >> Applications Analyst/Programmer > >> Microsoft Certified Systems Engineer > >> Oracle Certified Professional DBA > >> North Carolina State University Libraries > >> Campus Box 7111 | Raleigh | North Carolina > >> ph.919.515.3855 | fax.919.513.3330 > >> E-mail: [EMAIL PROTECTED] > >> > >> > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
