Community Member Profile

Recent Blog Comments By Seb Duggan

• Converting An IP Address To An Integer Using MySQL (Thanks Julian Halliwell)

  Posted on Jan 30, 2010 at 6:33 AM

  Here are two MS SQL functions to do the conversions: (hope the pre tags work in these comments...) <pre> ALTER FUNCTION [dbo].[ip2number] ( @ip varchar(15) ) RETURNS bigint AS BEGIN DECLARE @numrep bigint DECLARE @start int, @end... read more »

• Converting An IP Address To An Integer Using MySQL (Thanks Julian Halliwell)

  Posted on Jan 29, 2010 at 9:49 AM

  I've come across this IP address conversion recently in the free GeoIP database. Makes it easy to convert your IP into a number, and find which range of IPs it lies in using BETWEEN. Of course, I'm using MSSQL, so had to write my own function (actually, a stored procedure) to do the convers... read more »

• How To Build A Custom jQuery Selector

  Posted on Jan 13, 2009 at 7:04 PM

  I appreciate that this may just be an example chosen to demonstrate the writing of a custom selector, but if not... Why would you not just use: $("li[title='foo']") And for both, you could use: $("li[title='foo'], li[title='bar']") The attribute matching also allows... read more »

• jQuery Data() Method Associates Data With DOM Elements - SWEET ASS SWEET!

  Posted on Nov 20, 2008 at 11:47 AM

  I discovered this feature a couple of weeks ago, and it's been a revelation to me! Hadn't yet got round to blogging it, and now you've beaten me to it...... read more »

• Using CAPTCHA In ColdFusion 8

  Posted on Jan 15, 2008 at 4:52 AM

  I've been using CAPTCHAs generated by cfimage recently, and came across a problem, which I've detailed on my blog (I've finally got round to setting one up!): http://sebduggan.com/posts/cfimage-gener... read more »

• Exercise List: Designing The Database Schema

  Posted on Oct 22, 2007 at 7:52 AM

  I second Zac's comment; I've also recently started prefixing foreign key fields with "frn_" - for example, if referring to joint_id from another table, I would name the column frn_joint_id. Just makes it clearer you're referring to another table...... read more »

• Nylon Technology Presentation - Some Of The Forgotten Functions

  Posted on Jun 15, 2007 at 8:27 PM

  The really useful one I'd forgotten about until recently is ValueList(). Saves all that unnecessary query looping!!... read more »

• Learning ColdFusion 8: CFImage Part I - Reading And Writing Images

  Posted on Jun 12, 2007 at 12:31 PM

  Don't know much about it myself - just what I deduced from poking and prodding!... read more »

• Learning ColdFusion 8: CFImage Part I - Reading And Writing Images

  Posted on Jun 12, 2007 at 11:19 AM

  Yes, you can call the images directly from the URL, but not if you stop the CF application service...... read more »

• Learning ColdFusion 8: CFImage Part I - Reading And Writing Images

  Posted on Jun 12, 2007 at 11:02 AM

  A couple of notes on the generated images and CFFileServlet... The images are created in <cf8root>/tmpCache/CFFileServlet/ - and then either in _cf_image/ or _cf_captcha/ (when you get on to your CAPTCHA tutorial!). Images are cleared out of the temp directory 5 minutes after th... read more »

• Lenny And Bo, ColdFusion Programmers (Vol. 3)

  Posted on Mar 30, 2007 at 12:51 PM

  Hmmm... not sure what it is, but there's something a bit similar between all three cartoons so far... ;-)... read more »

• jQuery Demo: Build A ColdFusion Guru

  Posted on Mar 12, 2007 at 10:21 AM

  I'd never heard of jQuery before Ben raved about it recently; but I now already find it indispensible - and incredibly easy to pick up! I've been using it for both front- and back-end interfaces, and after three weeks of using jQuery have found myself answering a load of newbies' questions... read more »

• You Really Shouldn't Be Here jQuery, My Wife Might Begin To Suspect Something

  Posted on Feb 6, 2007 at 10:08 AM

  Now that does look cool... Yet again, reading Ben's blog means I'll lose several hours of productive time while I play with a new toy. (But as usual, it will save me many hours in the long run!)... read more »

• PLEASE HELP! Why Is This Application.cfc Throwing Errors?

  Posted on Oct 18, 2006 at 11:32 AM

  Works fine for me too - CF MX 7 on Windows 2003 server... Everyone here has run it successfully; have you tried deleting your files and recreating them from what you've posted on the blog?... read more »

• Case Insensitive Java Regular Expressions - How Did I Miss That!?!

  Posted on Sep 30, 2006 at 10:50 AM

  So what exactly are the benefits of using the Java string classes? Is it just a performance issue?... read more »

• XStandard ColdFusion Web Services Solution

  Posted on Sep 29, 2006 at 10:33 AM

  Just trying to decide whether I want a solution that needs software installing on each client computer - rather goes against the grain of a web-based application...... read more »

• Randomly Sort A ColdFusion Array (Updated) - Thanks Mark Mandel

  Posted on Sep 29, 2006 at 8:19 AM

  Wow, that's so much simpler than my method of getting a random selection of sidebar buttons from a SQL query (which basically entailed getting the first random number, getting the second and checking it wasn't the same as the first, getting the third etc...). Not what you'd call efficient c... read more »