Ian, What about creating a Flex based tool that allows users to choose the table they want to get the data from and then the columns for the table (that you wanted to be able to select by) would be available. Basically making a 'drag and drop' kinda query builder. where the users don't type anything, but are allowed to select what they want that is available.
That's my $.02 Rob On Thu, Apr 23, 2009 at 10:34 AM, Ian Skinner <h...@ilsweb.com> wrote: > > Did I get your attention? Luckily these are read-only queries, but still! > > I have a meeting this afternoon to discuss reworking/developing an > interface to allow anonymous, anybody in the world, users to develop add > hock queries on a respectably large database. This database gets about > 2.5 million transactions, and growing, a year and has been around since > 1973. It is public data, so we need to provide public access to it. We > would like it to be self service public access so the public can stop > bothering us for the data and we can spend more time on fun projects :) > > There is currently a form based interface, but it has serious > limitations and is no longer serving its role well. So this meeting is > to discuss what to do about this and how much time and effort it might > take. I am soliciting you all for ideas I may be overlooking on > possible solutions and|or gotcha's for something like this. So fire > away please. > > Thank You > Ian > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4