> Not sure cfspreadsheet exists in CF MX7 ???
It isn't. If you're using 7 you'll need to build a comma or
tab-delimited list for each row and write each line to a CSV file
which can be opened in Excel. You can use the ListAppend() function
to build the list (use chr(9) as the delimiter if you want a
tab-delimited list, it will use a comma by default). You can use the
CFFILE tag with the action="append" and addnewline="yes" attributes to
build the file in lieu of the cfspreadsheet tag (which can do a lot
more, but building the file manually isn't so bad for basic stuff).
> For the button , it should not run after the post as the
> information is already available. on the form
On the form, yes, but that data needs to make its way back to the
server so you can run your query and generate the report. Your app is
going to flow like:
1. Run page and output the form with options.
2. Submit form (post) back to the server.
3. Run page and see form values, run query, generate report, and
inform the user or redirect.
Something like...
<cfif isDefined("form.btnSubmit")>
<!--- Run query and generate file here. --->
<!--- Output a notice to let the user know we're done or redirect here. --->
<cfelse>
<cfform method="post">
<!--- form fields --->
<cfinput type="submit" name="btnSubmit" value="Run Report">
</cfform>
</cfif>
This is a really basic example, but essentially it will output your
form and submit back to itself, see that the form variables are
present (specifically the submit button) and run the query and
whatever else needs to be done. Usually it would be more complex but
this should get you going in the right direction.
-Justin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5502
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
