So, I kind of found something that I'm looking for at "http://plugins.jquery.com/project/SQL_QUERY_BUILDER";. The Tables and Columns are static but I'm looking in to changing that so it's a little bit more real time.
Tom >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 > > >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:329396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
