Community Member Profile

Recent Blog Comments By tony petruzzi

• ColdFusion GetPageContext() Massive Exploration

  Posted on Feb 4, 2010 at 9:06 AM

  anyone know how you can get the same data as getParameterMap() returns only for a multipart form post? james and i have been hunting around and need to get this for something we're working on in cfwheels.... 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.... 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 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 int... 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 th... 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-Foun... 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, henc... read more »

• Using ColdFusion To Stream Files To The Client Without Loading The Entire File Into Memory

  Posted on May 15, 2008 at 10:08 AM

  @eric and todd, you do know that you can save the receipt and write the purchase off at the end of the year.... read more »

• Using ColdFusion To Stream Files To The Client Without Loading The Entire File Into Memory

  Posted on May 14, 2008 at 4:29 PM

  can anyone confirm that the behavior being presented is still present is cf8? remember that the file libraries got a complete overhaul. this might be something to also pass a long to the open blue dragon committee.... 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... 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 ma... 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 o... read more »