Bob Clingan

Recent Blog Comments By Bob Clingan

• Ask Ben: Keeping Close Track Of Who Is Currently Online

  Posted on Aug 27, 2009 at 10:49 AM

  Check out: http://whosoncfc.riaforge.org/ There is also a version that uses a DB for storage.... read more »

• June 1st 2008 - National Regular Expression Day! (Post A Comment, Win A Prize)

  Posted on May 28, 2008 at 11:01 AM

  Regex rocks!... read more »

• SQL Server Text Matching Is Case INSENSITIVE

  Posted on May 23, 2007 at 12:47 PM

  If you are using SQL Server, check out the COLLATE clause to make searches case sensitive....... read more »

• Getting A Random Date Between Two Given Dates In ColdFusion

  Posted on May 7, 2007 at 2:26 PM

  You should consider using including a calendar table in your database- it makes life a whole lot easier! Just creating a simple table containing the date, whether is is a weekday, the year, quarter, month, day, day of week, month name, dayname, week number, holiday, etc. makes picking random days or... read more »

• Guess The Coin Amount, Win Cool Prizes

  Posted on Mar 23, 2007 at 2:11 PM

  $69... read more »

• Parsing CSV Values Using A Standard File Format

  Posted on Jan 25, 2007 at 10:07 AM

  I've started doing everything on the database server side using DTS packages- makes life a whole lot easier. Although if you are using something other than SQL Server, I guess you have to go that route.... read more »