I have a website (www.chaosmarch.com (http://www.chaosmarch.com/)) that uses coldfusion and a access 2000 db. the main feature is the technical readout section. currently, I'm using a series of db queries to generate the list tables in html.

I'd like to generate a xml file(s) that will contain the table data and the same mouseover effect that's in place now.

The queries are no problem, since they're already in place, but what about creating the xml/xslt template? I've played around a little with the db & cf/xml but the files are always huge.

No rush on this. I'm going on vacation for a few days and thought I'd throw this out there.

TIA

Chris

it would help if I explained the query. (I'm at work now and don't have the code handy.)

it pulls the following fields: ID (autonumber), Name, Tonnage, WeightClass, and several navigation and hit counters and sorts by Tonnage and Name.
currently I have up to four separate queries per section, one for each weight class. I don't know if it's possible to consolidate the queries into one and do a <cfoutput group=""> but that would be cool and cut down on the system overhead.

Also, has anyone worked with the cachedwithin feature in the cfquery? how useful is it? The examples I've seen look interesting, but I'm not willing to insert it into the code until I've had a chance to thoroughly test it.