How to create a form where the user enters there own query?
Posted on 2004-08-02
I would like to create a web form that will send a complete query to the action page.
In other words, I want the user to be able to design their query in this form, then submit it to the action page and it gets plugged into the CFQUERY tag of the action page.
This would be just a select query, not a insert, edit or delete.
Also, the field names and number of fields would need to be dynamic. Which would be determined by the user's query from the form.
Is this possible? If so, is there a code sample I can go by?