Long story short, I need to create an XML file from a SQL table preferably with
CF.

Right now I'm using a test table just to figure out how to do it. I can write
the query for XML fine.

SELECT * FROM testing FOR XML AUTO

Now how do I output the results of the query? I can't call the column names
because it says they don't exist. Any help would be appreciated, thanks.