Thanks Alan! It's knowing little things like that that keep me from considering myself a skilled cfml'r.
It makes total sense to me, but it didn't cross my mind either. Let me think about how I can work that into building the query I need. I would run the original query, then loop through it. Should I build another query.. or build an array? -Jason -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
