>> 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
Hi Justn,
anoither related question tyo appendlist ,
can i caopy paste excle sheet ( 36 rows X 4 Columns ) into textarea and then
use appendlist to reorder them and insert them into data base?
thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:5519
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
