I'm not sure if this is remotely what you want, but have you checked out querysim? It just seemed vaguely like what you're looking for even though I've missed this entire conversation.
http://www.cflib.org/udf.cfm?ID=255 Mike Not for this issue, because I can't outer join a CF created query with another query. Query of Query does not support outer joins! Oh I hope that comes soon. I run across the need for a Query of Query outer join three or four times a year. And it is always such a pain to work around. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229711 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

