<div>
I cannot use the cfcontent tag on my host site.<br />
Is there another way to export my cfquery to excel?
</div>


I cannot use the cfcontent tag on my host site.
Is there another way to export my cfquery to excel?

<div>
not that I know of using ColdFusion.<br />
Although there may be a custom tag available somewhere.<br />
But if your host won't allow cfcontent, then they probably don't allow custom tags.<br />
<br />
Get a new host!<br />
There are several very affordable ColdFusion hosts who do not put restrictions on you.<br />
Your current host not allowing certain tags really means that they don't know how to configure each customers sandbox correctly so they just apply a blanket restriction.<br />
Bogus!<br />
<br />
Good luck ...
</div>


not that I know of using ColdFusion.
Although there may be a custom tag available somewhere.
But if your host won't allow cfcontent, then they probably don't allow custom tags.

Get a new host!
There are several very affordable ColdFusion hosts who do not put restrictions on you.
Your current host not allowing certain tags really means that they don't know how to configure each customers sandbox correctly so they just apply a blanket restriction.
Bogus!

Good luck ...

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have two parts to this question:<br />
1. &nbsp;How can I export my query to Excel when the user clicks on the link to the page with the query in it.<br />
2. &nbsp;Is it possible to not have to list all the fields in the query for the output on the query page?<br />
<br />
I Have some simple reports to do. &nbsp;The table has probably about 40 fields.<br />
I do not want to list the query and then list all the fields in the query for output.<br />
I want to do the list of the query results dynamically.
</div>
</div>


Hi,

I have two parts to this question:
1.  How can I export my query to Excel when the user clicks on the link to the page with the query in it.
2.  Is it possible to not have to list all the fields in the query for the output on the query page?

I Have some simple reports to do.  The table has probably about 40 fields.
I do not want to list the query and then list all the fields in the query for output.
I want to do the list of the query results dynamically.

How to have a query output to Excel without listing every field?

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.