Community Member Profile

Recent Blog Comments By Joe Mastroianni

• ColdFusion Implicit Getter Has Incorrect Type For Being Called As A Function

  Posted on Apr 1, 2013 at 10:37 AM

  I've run into a similar problem. Under heavy load,one of my implict getters starts acting strangely but in a different way. I have a DocumentHeaderService Object which gets me a DocumentHeaderID via an implicit getter. I then pass that ID into a generation function which build a header from XML.... read more »

• ColdFusion ORM: A Guide To Developing Applications Using ColdFusion ORM By John Whish

  Posted on Oct 31, 2011 at 11:11 AM

  God, sorry for all the tyops in my previous post. It's definitely Monday morning!... read more »

• ColdFusion ORM: A Guide To Developing Applications Using ColdFusion ORM By John Whish

  Posted on Oct 31, 2011 at 11:09 AM

  Gonna have to give this a read. I have a large project which we started intrgrating ORM into. I started learning the hard way wait CF 9.0, it'd be nice to have some independent confirmation I'm thinking the right way.... read more »

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

  Posted on Aug 24, 2011 at 12:29 PM

  @Anna, In my experience you're much better off doing a GROUP BY as opposed to DISTINCT.... read more »

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

  Posted on Aug 19, 2011 at 10:32 AM

  @Ben, So I thought, those in clauses can be murder. I just have an unfounded dislike of inserting data only to immediately delete it. But like you said, it's a counter intuitive approach.... read more »

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

  Posted on Aug 19, 2011 at 10:23 AM

  Couldn't you just do something like insert into guest(id, name) select u.id, u.name from user u where u.id not in ( select id from profile ) Not sure if it'd be faster but I imagine the insert then delete would play havoc with any indexes.... read more »

• JSON: Minor But VERY Important Detail Creating Syntax Error: Invalid Label

  Posted on Jul 14, 2011 at 9:33 AM

  Add me to the list! Still this whole setup seems pretty fragile to me. I wonder if TPTB would consider adding a parameter to CF's SerializeJSON() function to include brackets?... read more »