Yes combining the queries is the ultimate answer. i was just in the beginnings of building this when i noticed that LIST problem and assumed at some point ill need to know how to do that. Silly me never even noticed that check box.
Ill most likely move it all off to a stored proc anyway. I will ultimately need to be able to create delete add too and subtract from families as children come and go from the system and or perpetrate or get perpetrated upon by other siblings. Sad but its the nature of this business. On 12/1/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > However, I'd be interested to see if this reported performance > > gain is really that big. > > The answer is, it depends. > > That is, I've seen several specific cases where it was no faster, or where > it was slower, to use CFQUERYPARAM than not to. However, in the aggregate > of > cases I've seen, it's usually enough faster to warrant doing it generally > to > improve performance (without measuring specific cases). > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
