D'oh! Neither are UDFs (which I suggested), though you could recreate
this process in a custom tag.

Jamie

On Tue, 9 Jul 2002 15:28:18 -0400 (EDT), in cf-talk you wrote:

>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]
>> >>
>> >>
>> >
>> 
>> 
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

Reply via email to