Mark; Is there any chance you could give a better explination on what you are trying to accomplish? Please use sudo code to explain, there might be someone out here in ACFUG land that has accomplished the same thing your are looking to do but in a different manner.
Thanks Jason L West --- Quote --- Learn to ask yourself at least three times through out your day, "Am I being productive or just active?", in order to keep yourself on track to what produces effective results instead of just looking efficient. "Fennell, Mark P." <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/10/2008 06:54 Please respond to [email protected] To <[email protected]> cc Subject RE: [ACFUG Discuss] queryNew() ? 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 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 ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor - Figleaf Software 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 ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor - Figleaf Software 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 ------------------------------------------------------------- ------------------------------------------------------------- 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 -------------------------------------------------------------
