Tony Petruzzi

Recent Blog Comments By Tony Petruzzi

• Tiny Test - An Exploration Of Unit Testing In ColdFusion

  Posted on May 8, 2013 at 2:35 PM

  If you want to look at another `drop-in` testing framework, give RocketUnit a look. it has one assert method that takes an expression so it can fit any scenario. its what we use to test cfwheels. if anything, it might give you some ideas on expanding TinyTest. official on riaforge: http://rocket... read more »

• Converting Dates Across Time Zones Using ColdFusion And Java

  Posted on Sep 23, 2011 at 9:41 PM

  Curious on why you didn't look at timezone.cfc. I've been using it for a long time and it works out nicely. The original project is up on riaforge.... read more »

• Mastering The ColdFusion Application Framework

  Posted on Jun 3, 2010 at 10:24 AM

  "When most people hear the term, "Framework," they think about products like ColdBox, Model-Glue, Mach-ii, and FW/1." CFWheels gets no love once again :(... read more »

• Exploring IIS Mod-Rewrite For Rewriting URLs In A ColdFusion Application

  Posted on Sep 2, 2009 at 8:31 AM

  FYI, ManagedFusion is another free url rewriter that also does reverse proxying for iis6 and iis7. One thing I like about it is that it run as a regular .net application so there are no isapi filters to install on iis6. http://www.managedfusion.com/products/... read more »

• Learning ColdFusion 9: EntityNew() vs. The NEW Operator / CreateObject()

  Posted on Aug 20, 2009 at 11:27 AM

  i haven't had the chance to play with cf9's orm stuff yet, but i'm wondering if there is anything out there about setting up and doing validations with the orm.... read more »

• Learning ColdFusion 9: CFScript Updates For Tag Operators

  Posted on Jul 24, 2009 at 10:48 AM

  @rick, i totally agree.... read more »

• Creating Tiny URLs Using ColdFusion

  Posted on Mar 25, 2009 at 11:12 AM

  although this approach is good. i think a better approach would be to use to use an algorithm to generate the tinyurls instead of letting the user enter them. you could generate a SHA1 and use the first 7 or so character from it (similar to what you can do in git to access commits) an use that as t... read more »

• Both MySQL and MS SQL Server Use @@Identity To Report Latest Auto-Incrementing Value

  Posted on Dec 10, 2008 at 10:35 AM

  @Lola my professional opinion is that you should ALWAYS use uuids. Now before everyone in auto-increment world goes nuts, i want you to think about how you would solve this problem if you use auto-increments in your database: How would you go about combining 17 separate databases into one databas... read more »

• Both MySQL and MS SQL Server Use @@Identity To Report Latest Auto-Incrementing Value

  Posted on Dec 9, 2008 at 11:37 AM

  @Andrew AMEN on that brother, however in MSSQL it's better to use a GUID (uniqueidentifier).... read more »

• Both MySQL and MS SQL Server Use @@Identity To Report Latest Auto-Incrementing Value

  Posted on Dec 9, 2008 at 10:45 AM

  "within the transaction session" all sql statements that get executed within a session. example would be doing an insert statement and then having that insert statement fire an insert trigger on the table. the transaction session contains two statement: one for the insert statement and one for the i... read more »

• Both MySQL and MS SQL Server Use @@Identity To Report Latest Auto-Incrementing Value

  Posted on Dec 9, 2008 at 10:33 AM

  might want to reconsider that. The latest version of MySQL is getting a lot of slack because of the many show stopper bugs it contains. http://www.eweek.com/c/a/Database/MySQL-Founder-Urges-Cautious-Approach-to-MySQL-51/ http://blogs.computerworld.com/mysql_5_1_released_with_crashing_bugs ht... read more »

• IMPORTANT UPDATE: XML Parsing Is WAY Faster Than ColdFusion Custom Tags

  Posted on Sep 4, 2008 at 4:56 PM

  @Ben, Awesome man, just awesome. I had a feeling it would be faster seeing how XPATH lookups are extremely slow in any language. It's going to blow your mind how fast your POI utility is when you rewrite it.... read more »

• ColdFusion Custom Tags Are Significantly Faster Than XML Parsing

  Posted on Sep 4, 2008 at 10:51 AM

  try removing the xmlsearch functions from the xmlparser code and access the data using dot | bracket notation. i bet you could shave off some seconds with that.... read more »

• MySQL Does Not Support IF / ELSE Statements In General SQL Work Flow

  Posted on Sep 2, 2008 at 12:50 PM

  to be honest, this is a good thing. less not forget that conditions are business logic and as such should be placed in stored procedures. i know there are people out there that will disagree but, facts are facts.... read more »

• The Philosophy Of Undocumented ColdFusion Features

  Posted on May 16, 2008 at 10:36 AM

  i really utilizing undocumented features just really boils down to what exactly the features does. in ben's defense, utilized the undocumented java object functions is really never going to hurt you from what i can see. the plain fact of the matter is that cf is written on top of java, hence it wil... read more »

• Compiling Several Linked Files Into One File

  Posted on Apr 8, 2008 at 10:15 AM

  if you have sessions enabled, you can just append session.sessionid to the url of the script: # <script type="text/javascript" src="./scripts.js?#session.sessionid#"></script> I do this to all the script and link tags so that it only downloads once for the session instead of downloadin... read more »

• Thoughts On Storing Duplicate / Calculated Data In The Database

  Posted on Mar 28, 2008 at 2:13 PM

  @Peter, i think you situation would be the perfect example where an indexed view could be used to increase performance. However if your DB doesn't support them, then yes I would have done EXACTLY what you did.... read more »

• Thoughts On Storing Duplicate / Calculated Data In The Database

  Posted on Mar 28, 2008 at 10:12 AM

  Views my friend... views.... read more »

• Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

  Posted on Mar 28, 2008 at 7:49 AM

  last thing about indexes any then I'll stop.... make sure that when you are examining the execution plan of a query, you look to see if the indexes used are doing a scan or a seek. the difference is that same as it would be for a table. a scan looks through the entire index for the matches, where ... read more »

• Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

  Posted on Mar 27, 2008 at 4:42 PM

  continuing with the indexes.... if you are using sql server and don't know what indexes to put on a table, just use the index tuning wizard that comes with it. the index tuning wizard can also help with a table that has too many indexes by finding the ones the table needs and dropping the others. a... read more »