Paul, I'd say you are a good candidate for either a stored procedure or query of a query. There's a short article on q of q on our dev resources page if you are interested:
http://www.cfwebtools.com/index_dev.cfm Mark -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 1:25 PM To: CF-Talk Subject: Custom Tags I have a question -- looking for a better way of doing things: Currently, I am using custom tags to run queries, and take the various bits of information and re-package it into queries, THEN packaging the results up into a WDDX Packet. Outside of the Custom Tag I am unpackaging the WDDX Packet (which is the query that I built in the Custom Tag) and then running my outputs on it to get the results. This seems like alot of jumping back and forth to get to the result Is it possible to do this differently? My whole goal is to run some pretty nasty queries/joins/hoops and bumps inside the custom tag, so the html group can then just run standard cfoutputs and/or cfloops to output the data. Anyone have any words of wisdom that might be a better solution? Thanks Paul Giesenahgen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder _________________________ _________________________ ____________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists