Yeah. I don't know if it was the right thing to do, but I basically just used a QoQ to selected the "desired" data and rebuilt the queryNew variable. Thanks. mf
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darin Kohles Sent: Wednesday, January 09, 2008 1:23 PM To: [email protected] Subject: RE: [ACFUG Discuss] queryNew() ? Your best bet is to simply to do a query of queries - you can then filter either columns or row using SQL <cfquery name="q_newQuery" dbtype="query"> SELECT row1, row5, etc... FROM q_oldQuery WHERE uncle like '%bob%' </cfquery> Darin Kohles, Application Developer [EMAIL PROTECTED] Digital Positions, Inc. 2289 Peachtree Road NE Atlanta, GA 30309 404-351-8878 support phone 404-351-2366 main phone 404-351-4055 fax http://www.d-p.com/ ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fennell, Mark P. Sent: Wednesday, January 09, 2008 1:04 PM To: [email protected] Subject: [ACFUG Discuss] queryNew() ? Is there anyway to delete data from a query? Yes, delete from a _query_ not from a table or other database object. See, I want to use the queryNew() family of functions to collect some data from the client before I stick it in the database, kind of like in a shopping cart. You should be able to smell the stench of AJAX... Can structDelete() be used? I seem to recall that this can be done. I just don't remember the details. Thanks. mf ------------------------------------------------------------- Annual Sponsor - Figleaf Software <http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor - Figleaf Software <http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
