I'm not totally sure what you are after-- I Googled "Quick Query" and all I could find was a MS Access plug-in. As for allowing your users to write their own queries, I really can't imagine doing this without an interface that enforced your specific business rules and limited them from running something really stupid. This is probably why the "query builders" I have seen before were specific to an application and its entities/relationships.
There may or may not be something built in CF out there, but if you really trust your users to run anything they want on the DB, then install Query Analyzer and give them a log in with only select permissions (The thought of that kind of scares me...), or try to define a handful of reports that funnel them in a specific direction where you can control the SQL statement, but they can filter, group, and sort by themselves. ~Brad -------- Original Message -------- Subject: Query/Report Builder From: Tom Jones <[email protected]> Date: Sun, January 03, 2010 5:12 pm To: cf-talk <[email protected]> Hello, I have been looking through the archives but really did not find much on this. I'm looking for a web based query builder. I want to let my users create their own queries. It must have been done before, so I really dont want to re-invent the wheel. I came across something called "Quick Query" but it's a ASP.Net thing and I'm not running on Windows nor do I really want to use ASP. :-) Are there any projects or something that will give me a head start or do I need to write it from scratch? Thanks, tom ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329393 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
