Joe Mastroianni

Recent Blog Comments By Joe Mastroianni

• Experimenting With The Amazon Simple Storage Service (S3) API Using ColdFusion

  Posted on May 11, 2015 at 10:51 AM

  @Jwarzi, According to this post, we're in good shape. It's more a question of chttp then anything else. CF11 might need a small tweak in JVM settings, CF10 and older are ok. http://www.trunkful.com/index.cfm/2014/12/8/Preventing-SSLv3-Fallback-in-ColdFusion... read more »

• Experimenting With The Amazon Simple Storage Service (S3) API Using ColdFusion

  Posted on Jun 20, 2013 at 9:08 AM

  @Ben & Tom In my cursory testing uploading to US Standard, I've been able to access the files immediately after upload. My uploader performs processing on the file on upload success. So it appears that the uploader can hit the file, but perhaps not clients hitting nodes in other regions. It re... read more »

• Experimenting With The Amazon Simple Storage Service (S3) API Using ColdFusion

  Posted on Jun 19, 2013 at 2:01 PM

  I have coincidentally been beating my head against the S3 API for the last week or so. One big "gotcha" I had to work around was file names and paths containing spaces. Remember to URL Encode your request! If you don't, the signature will be for the non-encoded value while the browser wi... read more »

• 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. S... 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 »