Nice job Brad. All it needs now is a sound track and a way to claim my free iPod.
What application have you found for it? -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, August 20, 2007 5:15 PM To: CF-Talk Subject: SQL Color Coding Ok, so a couple months ago I asked the list (http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:52544) if anyone knew of any functions to color code a string of SQL for display. I got crickets back, so I finally got around to trying my hand at it. I figured to be fair; I would post it here in case: 1) Anyone wanted the same functionality 2) Anyone wanted to shred my code I will say it doesn't perform too badly with a decent sized piece of code, but when I pasted in a stored proc which was over 1800 lines of code, it took a few seconds to crank through it. I initially debated whether or not I should do a series of regex replacements, or iterate over each token in the string and deal with them one at a time. I chose the latter mostly because I am not very good at regular expressions, but I would like to attempt the former approach for a speed comparison. http://www.bradwood.com/sql_color_coding/ Please check it out and offer me some constructive criticism. (I'm already sorry I asked) Thanks. ~Brad P.S. The closest thing I was able to find on the 'net was http://jspwiki.org/wiki/ColorCodePlugin_page, but it is all in Java which mostly just confused me. :-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286810 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
