Jon Hartmann

Recent Blog Comments By Jon Hartmann

• MySQL: The Multi-part Identifier "u.id" Could Not Be Bound

  Posted on Dec 23, 2008 at 9:35 AM

  I've done this quite a few times. Its why I've trained myself to always use the alias, even when working with a single table.... read more »

• ColdFusion ARGUMENTS Keys Always Exist, Even When Not Required

  Posted on Dec 17, 2008 at 4:55 PM

  I'd imagine that <cfloop collection="#struct#" item="key" /> is executed similarly to <cfloop list="#StructKeyList(struct)#" index="key" />, so I'd say that the problem is probably that StructKeyList() returns the keys with null values.... read more »

• ColdFusion REFind() Cannot Find The Empty String

  Posted on Dec 17, 2008 at 3:09 PM

  @Ben Yep, that's why I worked through a list of Pattern based utility functions over on my site :)... read more »

• ColdFusion ARGUMENTS Keys Always Exist, Even When Not Required

  Posted on Dec 17, 2008 at 3:07 PM

  @Ben I can follow that, but ColdFusion doesn't really have a concept of null values, so I think its odd to have an unexpected behavior based on interactions with null values. Either it shouldn't deal with nulls at all or it should behave like it does with null values in query sets (return an empt... read more »

• ColdFusion REFind() Cannot Find The Empty String

  Posted on Dec 17, 2008 at 9:50 AM

  This is just one of the many reasons why I prefer Pattern matching to the built in Regex functions. The expressions that Pattern recognizes are broader and more accurate then the built in functions.... read more »

• ColdFusion ARGUMENTS Keys Always Exist, Even When Not Required

  Posted on Dec 17, 2008 at 9:44 AM

  If you have default values, but need to tell if the argument was passed in or not, you could define a struct with those values inside the function, do the tests to see if the values exist, and then do the non-destructive StructAppend(). Its a hack, but it does work. That is an interesting bug you f... read more »