David Hammond

Recent Blog Comments By David Hammond

• JavaLoader Needs Access To Internal ColdFusion Java Components In ColdFusion 2018

  Posted on Sep 21, 2021 at 1:16 PM

  I plugged my error message into Google without much hope of a quick solution, fully ready to dig through pages and pages of not-quite-applicable suggestions. Imagine my surprise when this came up first in the results, with exactly the right info! Thanks, Ben! By the way, I ran into this ... read more »

• Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

  Posted on Aug 19, 2011 at 11:24 AM

  @Ben A lot of it depends on what proportion of user records have corresponding profile records. If most of them do, then exists should perform well. If most of them don't, not so much. I'm guessing that the reason your insert/delete method works well is that there aren't that many records to del... read more »

• Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

  Posted on Aug 19, 2011 at 11:06 AM

  Not sure if it would be any different from JoeM's query, but my first instinct would be to use an exists subquery: insert into guest(id, name) select u.id, u.name from user u where not exists ( select * from profile where userID = u.userID )... read more »

• Using Slice(), Substring(), And Substr() In Javascript

  Posted on Mar 28, 2011 at 11:13 AM

  I'm with you -- I never even noticed the string slice() method before for some reason. Thanks for pointing it out! I've always just used the substring method, but the ability to use negative indexes could definitely come in handy. There are probably cases where you might want any negative numbe... read more »

• The User Experience (UX) Of Comments vs. Conversation

  Posted on Oct 10, 2010 at 5:33 PM

  Wow, I must really be out of it because I had no idea that "inline" blog comments were going away. I guess I'm backwards anyway, because I'm not into Twitter and if I have anything useful to say, I usually can't express it in 140 characters or less. In other words, I totally agree with y... read more »

• Creating A "Down For Maintenance" Page Using Application.cfc

  Posted on Oct 19, 2009 at 1:10 PM

  Well, to follow up on my previous comment ... I tried the same thing on the different server and "The service is unavailable." was not included in the response body. The only significant difference between the two servers that I can think of is that the one displaying the text is Windows 2008, and... read more »

• Creating A "Down For Maintenance" Page Using Application.cfc

  Posted on Oct 19, 2009 at 12:15 PM

  This is very helpful. One minor problem I came across is that setting the status code to 503 seems to automatically output "The service is unavailable." to the body of the response as well as the header. Since the site I'm working on has to be down for a significant amount of time, and I have a pr... read more »