Can you specify the columns that get written to a spreadsheet when using the query attribute of cfspreadsheet?

[pmlink360]

Hello, I wanted to see if you can control which columns from a query get written to a excel spreadsheet. I have some items in my query that I do not want in the spreadsheet but need for my query, if that makes sense.

Thanks.

Steve

[EddieLotter]

There are no parameters in the cfSpreadsheet tag to choose specific columns, however you can use a query of queries (About Query of Queries - ColdFusion English Documentation - Adobe Learning Resources) to get a query object with a subset of columns to pass to the tag.