<?xml version="1.0" encoding="utf-8"?>

			<rss version="2.0" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:cc="http://web.resource.org/cc/" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd">

			<channel>
			<title>The No-Dans Club - ColdFusion</title>
			<link>http://www.nodans.com/index.cfm</link>
			<description>ColdFusion, Flex, Ajax and other items of interest</description>
			<language>en-us</language>
			<pubDate>Thu, 02 Sep 2010 12:48:37 -0700</pubDate>
			<lastBuildDate>Mon, 29 Mar 2010 08:06:00 -0700</lastBuildDate>
			<generator>BlogCFC</generator>
			<docs>http://blogs.law.harvard.edu/tech/rss</docs>
			<managingEditor>sipacate@gmail.com</managingEditor>
			<webMaster>sipacate@gmail.com</webMaster>
			<itunes:subtitle></itunes:subtitle>
			<itunes:summary></itunes:summary>
			<itunes:category text="Technology" />
			<itunes:category text="Technology">
				<itunes:category text="Podcasting" />
			</itunes:category>
			<itunes:category text="Technology">
				<itunes:category text="Tech News" />
			</itunes:category>
			<itunes:keywords></itunes:keywords>
			<itunes:author></itunes:author>
			<itunes:owner>
				<itunes:email>sipacate@gmail.com</itunes:email>
				<itunes:name></itunes:name>
			</itunes:owner>
			
			<itunes:explicit>no</itunes:explicit>
			
			<item>
				<title>Special Guest Josh Adams Presents ColdFusion Builder in RTP March 30th</title>
				<link>http://www.nodans.com/index.cfm/2010/3/29/Special-Guest-Josh-Adams-Presents-ColdFusion-Builder-in-RTP-March-30th</link>
				<description>
				
				Special Guest, and TACFUG favorite, Josh Adams from Adobe will visit March 30th to present a special session on ColdFusion Builder.
Food and drink will be provided and all are welcome.

Directions and RSVP are at the &lt;a href=&quot;http://tacfug.org/index.cfm?event=showMeeting&amp;meetingID=1C978BDE-15C5-FC25-8C7091795091F036&quot;&gt;TACFUG Home Page&lt;/a&gt;

Make sure to tell your friends and co-workers about this special event! 
				</description>
				
				<category>TACFUG</category>
				
				<category>ColdFusion</category>
				
				<pubDate>Mon, 29 Mar 2010 08:06:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2010/3/29/Special-Guest-Josh-Adams-Presents-ColdFusion-Builder-in-RTP-March-30th</guid>
				
				
			</item>
			
			<item>
				<title>I present Making Bad Code Good 2010 to The CFMeetup at Noon Today</title>
				<link>http://www.nodans.com/index.cfm/2010/3/18/I-present-Making-Bad-Code-Good-2010-to-The-CFMeetup-at-Noon-Today</link>
				<description>
				
				If you can &lt;a href=&quot;http://tinyurl.com/cfmeetup&quot;&gt;join the Online ColdFusion Meetup&lt;/a&gt; today (March 18th) at noon EST, we&apos;ll talk about code, code quality and show you some techniques to help you make bad code good.

This presentation picks up where my 2009 Making Bad Code Good presentation leaves off. Same great concept with all new code samples and techniques.

If you work on a legacy application, or on code built by lots of developers over the years, you likely laugh your way through this presentation. I promise to be thought provoking and challenge the way you write code. In this session, we&apos;ll look at lots of code samples and walk through making incremental changes to speed development, reduce errors and make life easier for everyone involved.

Ideas and concepts in this presentation will help you improve your existing applications and write more maintainable code. 
				</description>
				
				<category>ColdFusion</category>
				
				<category>Conferences</category>
				
				<pubDate>Thu, 18 Mar 2010 06:27:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2010/3/18/I-present-Making-Bad-Code-Good-2010-to-The-CFMeetup-at-Noon-Today</guid>
				
				
			</item>
			
			<item>
				<title>Why you should submit beginner/intermediate sessions to NCDevCon</title>
				<link>http://www.nodans.com/index.cfm/2010/3/15/Why-you-should-submit-beginnerintermediate-sessions-to-NCDevCon</link>
				<description>
				
				NCDevCon is a free two day conference on ColdFusion, Flash, Flex, AIR, HTML, Javascript and CSS. We&apos;ve been building on the success of last year, and making bigger moves to grow the community. We are a victim of our own success.

What I mean by that is, we&apos;ve taken some big strides to find developers who aren&apos;t typically at Adobe conferences. Last year we held a free ColdFusion training day and also a free Flex training day. These training sessions were well received by the audience and much good was done.

This year, the interest for these classes has already quadrupled. We have many more developers who have no exposure to either ColdFusion or Flex. As such, we&apos;d like to ask the community for help.

Many of the speaker submissions for NCDevCon are advanced sessions. We want those sessions to be included in our conference. We also want some good beginner/intermediate content as well.

Of particular interest to us would be sessions that teach newcomers to ColdFusion, how to do common tasks with ColdFusion.

The format for these would be 2 hour hands-on blocks. You provide the content and a step by step process, and we&apos;ll provide Teachers Assistants to help you keep the class on track. We&apos;ll also take care of making sure the attendees have the right software installed. 

This is a great way to help your fellow developers and future developers. We promise to give you the star treatment while you are with us!

Some examples of sessions we&apos;d like to see are:

&lt;ul&gt;
&lt;li&gt;How to build a contact form&lt;/li&gt;
&lt;li&gt;How to build a dynamic product list&lt;/li&gt;
&lt;li&gt;Building a data driven JQuery widget with ColdFusion&lt;/li&gt;
&lt;li&gt;Reusing layouts in ColdFusion&lt;/li&gt;
&lt;li&gt;Whatever else you can think of&lt;/li&gt;
&lt;/ul&gt;

So, if you would like to take part in this unique opportunity, &lt;a href=&quot;https://spreadsheets.google.com/viewform?formkey=dDl0dm1xWmRTRlZBdEVNTjhUVEl5Qmc6MA&quot;&gt;let us know.&lt;/a&gt; We thank you in advance for the consideration. 
				</description>
				
				<category>ColdFusion</category>
				
				<category>Flex</category>
				
				<category>Conferences</category>
				
				<pubDate>Mon, 15 Mar 2010 09:18:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2010/3/15/Why-you-should-submit-beginnerintermediate-sessions-to-NCDevCon</guid>
				
				
			</item>
			
			<item>
				<title>How to customize the ColdFusion AutoSuggest</title>
				<link>http://www.nodans.com/index.cfm/2010/1/13/How-to-customize-the-ColdFusion-AutoSuggest</link>
				<description>
				
				ColdFusion 8 and 9 have an autosuggest functionality that just couldn&apos;t be simpler. 
If you want to have an autosuggest input on the screen, you can do it with a single line of code:
&lt;code&gt;
&lt;cfinput type=&quot;text&quot; name=&quot;language&quot; autosuggest=&quot;english,spanish,french&quot;&gt;
&lt;/code&gt;

That snippet will place an autosuggest box on the screen and allow a choice of english, spanish or french. Snazzy yeah? 

If you want, you can bind the autosuggest to a javascript function, or directly to a CFC, making data retrieval and formatting very simple. 

&lt;code&gt;
&lt;cfinput type=&quot;text&quot; name=&quot;language&quot; autosuggest=&quot;javascript:doSomethingJavascripty( {cfautosuggestvalue} )&quot; /&gt;
&lt;/code&gt;

&lt;code&gt;
&lt;cfinput type=&quot;text&quot; name=&quot;language&quot; autosuggest=&quot;cfc:DoSomething.coldFusiony( {cfautosuggestvalue} )&quot; /&gt;
&lt;/code&gt;

You can also make more complex examples, take a look at &lt;a href=&quot;http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f51.html&quot;&gt;the ColdFusion 9 Documentation for Autosuggest&lt;/a&gt; for some ideas.
All this is possible because ColdFusion used the extensive YUI library under the hood. The control used by the ColdFusion Autosuggest is the &lt;a href=&quot;http://developer.yahoo.com/yui/docs/YAHOO.widget.AutoComplete.html&quot;&gt;YUI AutoComplete widget&lt;/a&gt;.  

Let&apos;s say you wanted to do something that the YUI AutoComplete offers, but isn&apos;t in the ColdFusion documentation, what do you do?  [More]
				</description>
				
				<category>Ajax</category>
				
				<category>ColdFusion</category>
				
				<category>Javascript</category>
				
				<pubDate>Wed, 13 Jan 2010 07:11:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2010/1/13/How-to-customize-the-ColdFusion-AutoSuggest</guid>
				
				
			</item>
			
			<item>
				<title>ColdFusion License Key Invalid?</title>
				<link>http://www.nodans.com/index.cfm/2009/12/29/ColdFusion-License-Key-Invalid</link>
				<description>
				
				I&apos;m having all my servers upgraded to ColdFusion 9. In the process we ran into a situation where a perfectly valid key was not accepted by the ColdFusion installer. 

&lt;strong&gt;The serial number that you entered is invalid&lt;/strong&gt;

After a little troubleshooting, Tim Geist at &lt;a href=&quot;http://viviotech.net&quot;&gt;Viviotech&lt;/a&gt; (top notch hosts) found an &lt;a href=&quot;http://kb2.adobe.com/cps/529/cpsid_52919.html&quot;&gt;Adobe KB on Invalid License Keys and Linux:&lt;/a&gt;

&lt;blockquote&gt;
When installing ColdFusion 9 Standard onto a Linux operating system, you may encounter the issue where the installer does not accept the serial number.   When you enter the number into the installer, you will receive a message similar to the following:

    * The message &apos;The serial number that you entered is invalid&apos;
    * A red cross will appear next to the Serial Number text field

The installer will not let you progress any further.
&lt;/blockquote&gt;
&lt;a href=&quot;http://kb2.adobe.com/cps/529/cpsid_52919.html&quot;&gt;Read More&lt;/a&gt;

Apparently, proceeding with the developer installation, then entering the license key in later fixes the issue. I&apos;m sure this will be remedied in a future point release of ColdFusion. 
				</description>
				
				<category>ColdFusion</category>
				
				<pubDate>Tue, 29 Dec 2009 15:48:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/12/29/ColdFusion-License-Key-Invalid</guid>
				
				
			</item>
			
			<item>
				<title>Hey look, Jamie Metcher is Blogging!</title>
				<link>http://www.nodans.com/index.cfm/2009/11/20/Hey-look-Jamie-Metcher-is-Blogging</link>
				<description>
				
				Jamie Metcher, one of the wild and talented Aussies, is blogging now at &lt;a href=&quot;http://lagod.id.au/blog/&quot;&gt;http://lagod.id.au/blog/&lt;/a&gt;. If you, (like me), wondered what an lagod is, &lt;a href=&quot;http://lagod.id.au/blog/?page_id=17&quot;&gt;Jamie explains why he chose lagod on one of his pages&lt;/a&gt;.

Happy blogging Jamie. 
				</description>
				
				<category>ColdFusion</category>
				
				<pubDate>Fri, 20 Nov 2009 13:35:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/11/20/Hey-look-Jamie-Metcher-is-Blogging</guid>
				
				
			</item>
			
			<item>
				<title>So you wanna plan a conference?</title>
				<link>http://www.nodans.com/index.cfm/2009/10/20/So-you-wanna-plan-a-conference</link>
				<description>
				
				We&apos;ve just finished up the &lt;a href=&quot;http://cfinnc.com&quot;&gt;CFinNC conference&lt;/a&gt; and by &lt;a href=&quot;http://www.cfinnc.com/page.cfm/event-info/random-twitters-about-cfinnc&quot;&gt;all&lt;/a&gt; &lt;a href=&quot;http://www.silverwareconsulting.com/index.cfm/2009/10/19/CFinNC-Rocked-the-Casbah&quot;&gt;digital&lt;/a&gt; accounts, it went rather well. Most things ran on time, lunch arrived promptly and the facility at NC State College of Textile was top notch.

I&apos;ve been an attendee, speaker, teacher and a sponsor before, but this was my first time from the OTHER side of the registration desk. I have a newly found appreciation for conferences and conference staff.

Since this was our first time planning a conference, we learned a lot. I&apos;ve heard rumors of other groups wanting to put on a similar conference and I want to share a few things we learned along the way.

&lt;ol&gt;

&lt;li&gt; It helps to have a &lt;a href=&quot;http://tacfug.org&quot;&gt;whole bunch of committed volunteers&lt;/a&gt; that see the vision and will take responsibility for completing tasks.&lt;/li&gt;
&lt;li&gt; It helps to have a &lt;a href=&quot;http://www.tx.ncsu.edu/&quot;&gt;very generous sponsor providing facilities, manpower, AV and Video recording&lt;/a&gt;, which if we&apos;d had to procure on our own would have blown our entire budget.&lt;/li&gt;
&lt;li&gt; It helps to have &lt;a href=&quot;http://cfinnc.com/page.cfm/sponsors&quot;&gt;committed financial and contributing sponsors&lt;/a&gt; that help provide the budget. There will be more expenses than you may think at first.&lt;/li&gt;
&lt;li&gt; It helps to reach out to the &lt;a href=&quot;http://lizfrederick.blogspot.com/&quot;&gt;illustrious conference diva Liz Frederick&lt;/a&gt; and get timely help and advice along the way.&lt;/li&gt;
&lt;li&gt; It helps to get an information organization strategy in place, so the team isn&apos;t having to dig through mountains of emails, twitters, mailing list and other channels just to get status on deliverables. Maybe use a forum or a collaboration system with ticketing or something for this. Email and Excel are not the answer!&lt;/li&gt;
&lt;li&gt; It helps to periodically test your Contact Us form. &lt;a href=&quot;http://cfinnc.com/post.cfm/recent-cfinnc-communication-patterns&quot;&gt;Or Bad things can happen&lt;/a&gt;.&lt;/li&gt;
&lt;li&gt; It helps to &lt;a href=&quot;http://cfinnc.com/post.cfm/what-the-heck-is-meat-option-2&quot;&gt;put out the menu&lt;/a&gt; and the schedule as early as possible so you can help folks know what to expect and how to arrange their travel plans.&lt;/li&gt;
&lt;li&gt; It helps to overcommunicate with speakers, sponsors and attendees. 
Seriously.&lt;/li&gt;
&lt;li&gt; It helps to go ahead and just make mediocre decisions earlier than wait and try to make great decisions later.&lt;/li&gt;
&lt;li&gt; It helps to understand that if you are running the conference, you will not have a single moment to socialize. You probably won&apos;t like this and neither will all your friends.&lt;/li&gt; 
&lt;li&gt; It helps to understand that there will be problems and snags and must be fixed, regardless of how much planning you do. Fix them quickly and no one will know they even happened.&lt;/li&gt;
&lt;/ol&gt;


There is plenty more we learned also, but we&apos;d like to hear from you. We put out a &lt;a href=&quot;http://cfinnc.com/post.cfm/take-the-cfinnc-attendee-survey&quot;&gt;Post Conference Survey&lt;/a&gt; to get a 360 degree view of the conference and find ways to improve, should we do this again in the near future.

Thanks to all the volunteers, sponsors, speakers and attendees who made this event special. We thank you all for honoring us with your presence.


DW 
				</description>
				
				<category>ColdFusion</category>
				
				<category>CFinNC</category>
				
				<pubDate>Tue, 20 Oct 2009 10:14:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/10/20/So-you-wanna-plan-a-conference</guid>
				
				
			</item>
			
			<item>
				<title>Get Free Model-Glue training this weekend!</title>
				<link>http://www.nodans.com/index.cfm/2009/10/20/Get-Free-ModelGlue-training-this-weekend</link>
				<description>
				
				As you&apos;ve probably seen, &lt;a href=&quot;http://www.model-glue.com/blog/index.cfm/2009/10/13/Free-ModelGlue-3-Training&quot;&gt;I&apos;m giving Free Model Glue training&lt;/a&gt; this weekend at &lt;a href=&quot;http://bflex.info/&quot;&gt;BFusion/BFlex in Bloomington, Indiana&lt;/a&gt;. This will be the last Free Model-Glue training before we start the MG Training Roadshow, which won&apos;t be free. (Unless I win the lottery, which could happen).

BFusion is a super-mega-low cost event ($10) that has &lt;a href=&quot;http://bflex.info/bfusion-2009&quot;&gt;excellent content by excellent speakers&lt;/a&gt;. Held on the campus of Indiana University, the vibe at the conference is very open and inviting. If you come, you can get lots of hands on training in ColdFusion and Flex basically for free. 

Did you know, BFusion was the inspiration for the &lt;a href=&quot;http://cfinnc.com&quot;&gt;CFinNC event&lt;/a&gt; this past weekend? Yep, good things happen at BFusion/BFlex. Folks get inspired, improve their skills and careers, and forge lasting friendships with really great people.

So cancel your weekend plans, get in the car, bus, plane, or train and head down. If you aren&apos;t totally impressed with BFusion/BFlex, I&apos;ll personally refund your $10.

&lt;a href=&quot;http://webdb.iu.edu/uitsfs/scripts/training/bfregistration.cfm&quot;&gt;Register for BFusion/BFlex Today!&lt;/a&gt;

DW 
				</description>
				
				<category>ColdFusion</category>
				
				<category>Conferences</category>
				
				<pubDate>Tue, 20 Oct 2009 07:51:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/10/20/Get-Free-ModelGlue-training-this-weekend</guid>
				
				
			</item>
			
			<item>
				<title>Model Glue:Gesture - Version 3.1 Presentation at CF.Objective(ANZ)</title>
				<link>http://www.nodans.com/index.cfm/2009/10/15/Model-GlueGesture--Version-31-Presentation-at-CFObjectiveANZ</link>
				<description>
				
				I&apos;ll be presenting on &lt;a href=&quot;http://model-glue.com&quot;&gt;Model-Glue 3, code named Gesture&lt;/a&gt;, at the &lt;a href=&quot;http://www.cfobjective.com.au/&quot;&gt;CF.Objective(ANZ) conference&lt;/a&gt;, taking place in Melbourne, Australia on November 12th and 13th.

I&apos;m glad I&apos;m able to go to this conference because the &lt;a href=&quot;http://www.cfobjective.com.au/go/program&quot;&gt;schedule&lt;/a&gt; is packed with quality material by highly decorated speakers. Having interacted with a number of Australian developers through mailing lists and chat, I&apos;m very pleased to meet some of the legends in person and to meet the very vibrant, entertaining ColdFusion community from Australia, New Zealand and Asia.

Seats are limited and there are less than 4 weeks until the conference. &lt;a href=&quot;http://cfobjective.com.au/go/register&quot;&gt;Register today&lt;/a&gt;!
I hope to see you there! 
				</description>
				
				<category>ColdFusion</category>
				
				<category>Conferences</category>
				
				<pubDate>Thu, 15 Oct 2009 15:53:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/10/15/Model-GlueGesture--Version-31-Presentation-at-CFObjectiveANZ</guid>
				
				
			</item>
			
			<item>
				<title>CFinNC is close to a sell out</title>
				<link>http://www.nodans.com/index.cfm/2009/10/9/CFinNC-is-close-to-a-sell-out</link>
				<description>
				
				When we started talking about planning the &lt;a href=&quot;http://www.cfinnc.com/&quot;&gt;CFinNC conference&lt;/a&gt;, we knew we wanted to provide the best possible training and education for zero cost. This goal was ambitious and required a large dedicated, experienced conference planning team with a large budget.

Since we were a small, volunteer, inexperienced group of programmers with zero budget, I&apos;ve been entertained and surprised at times by the proceedings. For those who don&apos;t know, the CFinNC planning team is pretty much the entire &lt;a href=&quot;http://tacfug.org&quot;&gt;Triangle Area ColdFusion User Group&lt;/a&gt;. This is the premiere ColdFusion User Group on the planet and anyone who thinks differently can come to &lt;a href=&quot;http://www.flickr.com/photos/adrocknaphobia/3842214845/in/set-72157621977870083/&quot;&gt;CFUnited for a smackdown in the Sumo Ring&lt;/a&gt;.

Thanks to the generosity of our sponsors and the creativity and dedication of our planning teams, we are set to have the very best Adobe Platform ever, in the state of North Carolina.

The good news for us, and the bad news for those who&apos;ve been delaying their registration, is we are close to sold out. &lt;em&gt;(Editors Note: Can a free conference really sell out?)&lt;/em&gt;

Conferences generally have two periods of rapid registrations, generally around the first two weeks of registration, and the last 2 weeks of registration. CFinNC starts Oct 17th, so we are definitely in the last 2 weeks. Though interestingly enough and based on highly complicated computer models, we&apos;ll have to close registration ahead of schedule. If you&apos;ve been postponing &lt;a href=&quot;http://cfinnc09.eventbrite.com/&quot;&gt;registration for CFinNC, do it now&lt;/a&gt;.

As my 9 year old Nephew so eleoquently put it, &lt;strong&gt;Snoozers are losers&lt;/strong&gt;. 
				</description>
				
				<category>ColdFusion</category>
				
				<category>CFinNC</category>
				
				<category>Conferences</category>
				
				<pubDate>Fri, 09 Oct 2009 09:30:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/10/9/CFinNC-is-close-to-a-sell-out</guid>
				
				
			</item>
			
			<item>
				<title>So you wanna learn Regex? - Part 5</title>
				<link>http://www.nodans.com/index.cfm/2009/9/29/So-you-wanna-learn-Regex--Part-5</link>
				<description>
				
				Welcome to So You Wanna Learn Regex? Part 5.
This is our last part of this series, mostly because I don&apos;t know a whole lot more than this. If you want more tutorials about regex, go bug &lt;a href=&quot;http://bennadel.com/blog&quot;&gt;Ben&lt;/a&gt;. He knows more about this than I ever will and I hear he has a blog...

In our last exercise, we looked at a simple way to add cfqueryparam to a bunch of queries. This was accomplished by making a pattern consisting of 3 groups then using one of the groups to populate a literal string.

In this exercise, we are going to clean up some data scripts. Let&apos;s suppose you are generating database scripts and your script generator puts the primary key in there. For whatever reason, you want to remove this.


&lt;h3&gt;Assume this set of declarations:&lt;/h3&gt;
&lt;pre&gt;
INSERT INTO `memberchallenge` VALUES (&apos;11&apos;, &apos;1&apos;, &apos;19&apos;, null, &apos;2008-11-14 14:07:59&apos;, &apos;2008-11-14 14:07:59&apos;, &apos;1&apos;, &apos;2008-11-14 14:07:59&apos;, &apos;0&apos;);
INSERT INTO `memberchallenge` VALUES (&apos;12&apos;, &apos;2&apos;, &apos;19&apos;, null, &apos;2008-11-14 15:40:51&apos;, &apos;2008-11-14 15:40:51&apos;, &apos;1&apos;, &apos;2008-11-14 15:40:51&apos;, &apos;0&apos;);
INSERT INTO `memberchallenge` VALUES (&apos;14&apos;, &apos;5&apos;, &apos;19&apos;, null, &apos;2008-11-14 20:14:26&apos;, &apos;2008-11-14 20:14:26&apos;, &apos;5&apos;, &apos;2008-11-14 20:14:26&apos;, &apos;0&apos;);
INSERT INTO `memberchallenge` VALUES (&apos;15&apos;, &apos;1&apos;, &apos;20&apos;, null, &apos;2008-11-23 18:19:31&apos;, &apos;2008-11-23 18:19:31&apos;, &apos;1&apos;, &apos;2008-11-23 18:19:30&apos;, &apos;0&apos;);
INSERT INTO `memberchallenge` VALUES (&apos;16&apos;, &apos;2&apos;, &apos;20&apos;, null, &apos;2008-11-23 18:20:09&apos;, &apos;2008-11-23 18:20:09&apos;, &apos;1&apos;, &apos;2008-11-23 18:20:09&apos;, &apos;0&apos;);
INSERT INTO `memberchallenge` VALUES (&apos;17&apos;, &apos;1&apos;, &apos;21&apos;, null, &apos;2008-11-25 20:32:44&apos;, &apos;2008-11-25 20:32:44&apos;, &apos;1&apos;, &apos;2008-11-25 20:32:44&apos;, &apos;0&apos;);
INSERT INTO `memberchallenge` VALUES (&apos;18&apos;, &apos;2&apos;, &apos;21&apos;, null, &apos;2008-11-25 20:33:01&apos;, &apos;2008-11-25 20:33:01&apos;, &apos;1&apos;, &apos;2008-11-25 20:33:01&apos;, &apos;0&apos;);
&lt;/pre&gt;

&lt;strong&gt;What we want, is to turn:&lt;/strong&gt;INSERT INTO `memberchallenge` VALUES (&apos;11&apos;, &apos;1&apos;, &apos;19&apos;, null, &apos;2008-11-14 14:07:59&apos;, &apos;2008-11-14 14:07:59&apos;, &apos;1&apos;, &apos;2008-11-14 14:07:59&apos;, &apos;0&apos;);
&lt;strong&gt;into:&lt;/strong&gt; INSERT INTO `memberchallenge` VALUES (&apos;1&apos;, &apos;19&apos;, null, &apos;2008-11-14 14:07:59&apos;, &apos;2008-11-14 14:07:59&apos;, &apos;1&apos;, &apos;2008-11-14 14:07:59&apos;, &apos;0&apos;);

&lt;em&gt;Note the first value in the VALUES statement has vanished.. this would be the primary key in our dataload script.&lt;/em&gt;
&lt;img src=&quot;/images/extras/PrimaryKeyRemovalRegexEclipse.jpg&quot; style=&quot;float: right; margin: .5em&quot; /&gt;

So as you know, we define this pattern in the gobbledegook of regular expressions. When read one chunk at a time, these actually make sense. We&apos;ll go through the exercise, then look at why it worked.

&lt;h3&gt;In Eclipse, perform the following:&lt;/h3&gt;  [More]
				</description>
				
				<category>Tutorials</category>
				
				<category>ColdFusion</category>
				
				<category>Regex</category>
				
				<pubDate>Tue, 29 Sep 2009 09:13:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/9/29/So-you-wanna-learn-Regex--Part-5</guid>
				
				
			</item>
			
			<item>
				<title>So you wanna learn Regex? - Part 4</title>
				<link>http://www.nodans.com/index.cfm/2009/9/28/So-you-wanna-learn-Regex--Part-4</link>
				<description>
				
				Welcome to So You Wanna Learn Regex? Part 4.
In our last exercise, we looked at a simple way to clean a whole bunch of strings. This was accomplished by making a pattern, then removing everything according to that pattern. 
This time we are going to add cfqueryparam to a query. Say for example, that you have a junior developer who has been turned loose on her first application and she&apos;s done a good job, except for she didn&apos;t use cfqueryparam. You just found this out and the site has to go live in 10 minutes and you have 200 queries to fix. Do you:

&lt;ul&gt;
	&lt;li&gt;a) Download the code to your laptop then pull the fire alarm to stall for time?&lt;/li&gt;
	&lt;li&gt;b) Start blasting your resume out on Monster.com?&lt;/li&gt;
	&lt;li&gt;c) Take a fistfull of aspirin, knowing your forearms will ache in the morning?&lt;/li&gt;
&lt;/ul&gt;

If you answered d) none of the above, please keep reading.


&lt;h3&gt;Assume this set of declarations:&lt;/h3&gt;
&lt;pre&gt;
UPDATE plant
	SET 	Symbol = &apos;#form.symbol#&apos;,
			SynonymSymbol = &apos;#form.SynonymSymbol#&apos;,
     		ScientificNameWithAuthor = &apos;#form.ScientificNameWithAuthor#&apos;,
     		CommonName = &apos;#CommonName#&apos;,
     		Family = &apos;#Family#&apos;
WHERE PlantCode = &apos;#form.plantCode#&apos;
&lt;/pre&gt;

&lt;strong&gt;What we want, is to turn:&lt;/strong&gt; &apos;#form.symbol#&apos;
&lt;strong&gt;into:&lt;/strong&gt; &amp;lt;cfqueryparam value=&quot;#form.symbol#&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt;
&lt;img src=&quot;/images/extras/CFQueryParamEclipseRegex.jpg&quot; style=&quot;float: right; margin: .5em&quot; /&gt;

So as you know, we define this pattern in the gobbledegook of regular expressions. When read one chunk at a time, these actually make sense. We&apos;ll go through the exercise, then look at why it worked.

&lt;h3&gt;In Eclipse, perform the following:&lt;/h3&gt;  [More]
				</description>
				
				<category>Tutorials</category>
				
				<category>ColdFusion</category>
				
				<category>Regex</category>
				
				<pubDate>Mon, 28 Sep 2009 08:50:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/9/28/So-you-wanna-learn-Regex--Part-4</guid>
				
				
			</item>
			
			<item>
				<title>So you wanna learn Regex? - Part 3</title>
				<link>http://www.nodans.com/index.cfm/2009/9/25/So-you-wanna-learn-Regex--Part-3</link>
				<description>
				
				Welcome to So You Wanna Learn Regex? Part 3.
&lt;img src=&quot;/images/extras/RemoveParentheticalsRegexEclipse.jpg&quot; style=&quot;float: right; margin: .5em&quot; /&gt;

In our last exercise, we looked at a simple way to wrap a function argument inside a new function. This was accomplished by making a pattern, defining a group and using a back reference. This time we will look at how to clean some strings. 

Say for example, that you run a website called &lt;a href=&quot;http://thehealthchallenge.com&quot;&gt;The Health Challenge&lt;/a&gt; and say for example, you wanted to use some of your fine tax dollar funded research to deliver motivating messages to the members.

Well, you could just happen across &lt;a href=&quot;http://www.smallstep.gov/take_small_steps_today.html&quot;&gt;Small Steps&lt;/a&gt; and just use their content. After all, it is in the public domain. So you happily cut a LARGE chunk of these from the web site, but now you have to clean them.


&lt;h3&gt;Assume this set of declarations:&lt;/h3&gt;
&lt;pre&gt;
(# 11)  	Avoid food portions larger than your fist.
(# 12) 	Mow lawn with push mower.
(# 13) 	Increase the fiber in your diet.
(# 17) 	Join an exercise group.
(# 20) 	Do yard work.
(# 24) 	Skip seconds.
(# 25) 	Work around the house.
(# 26) 	Skip buffets.
(# 29) 	Take dog to the park.
(# 30) 	Ask your doctor about taking a multi-vitamin.
....( 700 more lines)
&lt;/pre&gt;

&lt;strong&gt;What we want, is to turn:&lt;/strong&gt; (# 11)  	Avoid food portions larger than your fist.
&lt;strong&gt;into:&lt;/strong&gt; Avoid food portions larger than your fist.
See, we like the content, we don&apos;t like the parentheticals nor the whitespace. Do we flex our forearms in preparation for a copy/paste session? Do we call KeyboardsAreUs.com and have 2 fresh keyboards airdropped, knowing we&apos;ll wear out some keys? (if you said yes, please delete your hard drive and apply at KFC.)
Regular expressions are our friends.  A Regex is a pattern matcher, and it can do stuff. We can see our code is repetitive and the pattern we want is: Get rid of the parentheticals and the extra whitespace. (Same stuff we&apos;d do over and over via cut/paste/etc, isn&apos;t it? Though in a copy paste, you are talking about 5 keystrokes per line times 700 lines. That is &lt;strong&gt;3500 keystrokes,&lt;/strong&gt; unless you type like me, in which case it would be nearly 4 million.)

So as you know, we define this pattern in the gobbledegook of regular expressions. When read one chunk at a time, these actually make sense. We&apos;ll go through the exercise, then look at why it worked.

&lt;h3&gt;In Eclipse, perform the following:&lt;/h3&gt;  [More]
				</description>
				
				<category>Tutorials</category>
				
				<category>ColdFusion</category>
				
				<category>Regex</category>
				
				<pubDate>Fri, 25 Sep 2009 08:25:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/9/25/So-you-wanna-learn-Regex--Part-3</guid>
				
				
			</item>
			
			<item>
				<title>So you wanna learn Regex? - Part 2</title>
				<link>http://www.nodans.com/index.cfm/2009/9/25/So-you-wanna-learn-Regex--Part-2</link>
				<description>
				
				Welcome to So You Wanna Learn Regex? Part 2.
In our last exercise, we looked at a simple way to add a new attribute to an HTML tag. This was accomplished by making a pattern, defining a group and using a back reference. This time we will look at a slightly more complicated use case.

&lt;h3&gt;Assume this set of declarations:&lt;/h3&gt;
&lt;pre&gt;
product.setColor(arguments.color);
product.setSize(arguments.size);
product.setCondition(arguments.condition);
product.setRating(arguments.rating);
product.setReliability(arguments.reliability);
product.setNeedsBatteries(arguments.needsBatteries);
&lt;/pre&gt;

&lt;strong&gt;What we want, is to turn:&lt;/strong&gt; product.setColor(arguments.color);
&lt;strong&gt;into:&lt;/strong&gt; product.setColor( htmlEditFormat(arguments.color) );
&lt;img src=&quot;/images/extras/HtmlEditRegexEclipseDialogue.jpg&quot; style=&quot;float: right; margin: .5em&quot; /&gt;

Normally, this would be a forearm/wrist fatiguing flail on the keyboard, furiously cutting/pasting and generally flapping about. Not so with Regular Expressions. A Regex is a pattern matcher, and it can do stuff. We can see our code is repetitive and the pattern we want is: Take Everything Inside The Parenthesis, and Wrap It In A htmlEditFormat() Function. (Same stuff we&apos;d do over and over via cut/paste/etc, isn&apos;t it?)

We can define this pattern in the gobbledegook defining a regular expression. When read one chunk at a time, these actually make sense. We&apos;ll go through the exercise, then look at why it worked.

&lt;h3&gt;In Eclipse, perform the following:&lt;/h3&gt;  [More]
				</description>
				
				<category>Tutorials</category>
				
				<category>ColdFusion</category>
				
				<category>Regex</category>
				
				<pubDate>Fri, 25 Sep 2009 08:24:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/9/25/So-you-wanna-learn-Regex--Part-2</guid>
				
				
			</item>
			
			<item>
				<title>So you wanna learn Regex? - Part 1</title>
				<link>http://www.nodans.com/index.cfm/2009/9/24/So-you-wanna-learn-Regex--Part-1</link>
				<description>
				
				I&apos;ve had a set of blog posts stewing in my brain for a while. Steve Nelson, last year, helped me out with a Regular Expression (Regex) and I made it a point to practice my Regex skills more. 
This series will show how to use Regular Expressions in Eclipse and we&apos;ll learn some helpful tips along the way.

This series is for you if you are the kind of developer that reads &lt;a href=&quot;http://www.bennadel.com/blog/1718-Ask-Ben-Displaying-A-Blog-Teaser-Showing-The-First-N-Words-.htm&quot;&gt;Ben Nadel&apos;s blog posts containing Regular Expressions&lt;/a&gt;, and has no idea what the heck he is talking about. Seriously Ben, this is unintelligible to us mere mortals:
&lt;blockquote&gt;
&amp;lt;cfset blogContent = reReplace(
 blogContent,
 &quot;&amp;lt;/?\w+(\s*[\w:]+\s*=\s*(&quot;&quot;[^&quot;&quot;]*&quot;&quot;|&apos;[^&apos;]*&apos;))*\s*/?&gt;&quot;,
 &quot; &quot;,
 &quot;all&quot;
) /&gt;
&lt;/blockquote&gt;

(It looks like a catnip crazed kitty went for a prance on a keyboard, doesn&apos;t it?)

Enough guffaws and such. On with the learning.

&lt;h3&gt;Editors Note:&lt;/h3&gt; 
&lt;p&gt;&lt;em&gt;Simply reading these blog posts aren&apos;t going to help you. Open eclipse, and copy/paste this stuff into your find/replace dialog. You&apos;ll learn more, or your money back!&lt;/em&gt;&lt;/p&gt;
So, firstly we need a use case. Let&apos;s pretend we are going through some old code and looking to add HTMLEditFormat around some arguments so that the forms won&apos;t break if there are quotes. 
&lt;img src=&quot;/images/extras/NewIDAttributeRegexEclipse.jpg&quot; style=&quot;float: right; margin: .5em&quot; /&gt;
&lt;h3&gt;Assume this set of declarations:&lt;/h3&gt;
&lt;pre&gt;
&amp;lt;input name=&quot;fred&quot; value=&quot;willy&quot; /&gt;
&amp;lt;input name=&quot;bill&quot; value=&quot;mickey&quot; /&gt;
&amp;lt;input name=&quot;erin&quot; value=&quot;harry&quot; /&gt;
&amp;lt;input name=&quot;baz&quot; value=&quot;pissette&quot; /&gt;

&lt;/pre&gt;

&lt;strong&gt;What we want, is to turn:&lt;/strong&gt; &amp;lt;input name=&quot;fred&quot; value=&quot;willy&quot; /&gt;
&lt;strong&gt;into:&lt;/strong&gt; &amp;lt;input name=&quot;fred&quot; id=&quot;fred&quot; value=&quot;willy&quot; /&gt;

Normally, this would be a forearm/wrist fatiguing flail on the keyboard, furiously cutting/pasting and generally flapping about. Not so with Regular Expressions. A Regex is a pattern matcher, and it can do stuff. 
We can see our code is repetitive and the pattern we want is: make a new attribute called &apos;id&apos; and populate it with the value from the attribute &apos;name&apos;... which is what we&apos;d do over and over via cut/paste/etc.

We can define this pattern in the gobbledegook defining a regular expression, of course, else I&apos;d be writing this post about Cute LOLCats, not Cute Regexes., wouldn&apos;t I? We&apos;ll go through the exercise, then look at why it worked.

&lt;h3&gt;In Eclipse, perform the following:&lt;/h3&gt;  [More]
				</description>
				
				<category>Tutorials</category>
				
				<category>ColdFusion</category>
				
				<category>Regex</category>
				
				<pubDate>Thu, 24 Sep 2009 09:18:00 -0700</pubDate>
				<guid>http://www.nodans.com/index.cfm/2009/9/24/So-you-wanna-learn-Regex--Part-1</guid>
				
				
			</item>
			</channel></rss>