That's alight Jim, I will be suing you for copyright infringement on my ideas though ;-)
-----Original Message----- From: Jim Rising [mailto:cfflex...@jimrising.com] Sent: 24 April 2009 00:59 To: cf-talk Subject: Re: YIKES! I must let internet users write SQL queries for our database! sorry guys... I guess I'm a bit late in the conversation, and my thread only showed the initial post. :) -- Jim Rising Serial Entrepreneur Software Engineer Web Developer "Knowledge work requires both autonomy and accountability." On Thu, Apr 23, 2009 at 6:57 PM, Jim Rising <cfflex...@jimrising.com> wrote: > I wouldn't do it. The reasons are obvious. I would find out specifically > what objects / methods they are wanting to allow access to, and I would > build an API to give access only to those objects / methods. Open it up as a > web service API and do it right. > > -- > Jim Rising > Serial Entrepreneur > Software Engineer > Web Developer > > "Knowledge work requires both autonomy and accountability." > > > On Thu, Apr 23, 2009 at 9: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:321924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4