> Did I get your attention? Luckily these are read-only queries, but still!
A couple of things: 1. Create a large selection of views with nice names, it will make it easier for your users to identify the tables and columns they are looking for. This will also remove or reduce the need for JOINs 2. The flex/AJAX query builder idea is a nice one, you could also provide a drop-down driven query builder and let it dynamically build the SQL statement for the user, then give the user the ability to edit the SQL. Since you're running off a replicated database the need for heavy regex checking might be reduced but you're still going to want to run the entire query through a screening to check for SQL injection. Good luck! Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:321857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
