Just in case some of you guys haven't seen it on mxna, I released a small utility last night called qBrowser. Its basically just a small app that allows you to play with and test your sql against your cf datasources. It has features like code coloring, history and a library, and you can restrict the sql statements you can run through it if you need to. It also supports cfqueryparam tags as well. It comes out of the box only allowing select statements.
We use it a lot to test out queries for execution times and to teach others sql. Its not really made to replace a query analyzer, but it is nice to be able to just quickly test a query and quickly browse the data in your datasources. If you are interested, you can get it from www.ryanguill.com/docs/ Let me know if you find any bugs, or have any feature requests. </shamelessplug> -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225681 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

