On Wed, Aug 24, 2011 at 3:06 PM, Mo Lay <[email protected]> wrote: > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5495 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
