>> My idea is the following : >> 1- pickup fields >> 2- build a query based on those field names euiv on the db side >> 3- Ezecute the query >> 4- export result to excel file. > >Sure. You can easily build a dynamic query based on form fields. > >And you can use cfspreadsheet to generate Excel files. > >I'd probably work first on getting the query right. Use cfdump to test >your results. When done, then look into cfspreadsheet. > >> Also is there a way to execute a query on onclick button ? > >Not quite sure I know what you mean. If your button is the submit >button, then it will happen when the form is poste
Hi Raymond, Not sure cfspreadsheet exists in CF MX7 ??? For the button , it should not run after the post as the information is already available. on the form let me know how it is possile to implement and it wold be greatly appreciated if you have a 1-2 lines code example...i am moreefficient when see a small example/ thanks a lot Ray. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5498 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
