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
