SCOTT BENNETT

Recent Blog Comments By SCOTT BENNETT

• I'm Beginning To Think That Much Of Programming Is Wildly Subjective

  Posted on Dec 6, 2022 at 8:57 PM

  @Ben, Objectively speaking, my subjective opinion is that the objective fact that some people don't care at all simply furthers the argument that formatting and syntax preferences are indeed subjective. 🤓... read more »

• I'm Beginning To Think That Much Of Programming Is Wildly Subjective

  Posted on Dec 6, 2022 at 7:21 PM

  I couldn't agree more! The "right way" now is very rarely going to be the "right way" in 5 or 10 years. I have never believed in the idea that there is only "one best way" to do things. (This mindset is a big reason why I have always resisted implementing commun... read more »

• A Database Column For "Date Updated" Has No Semantic Meaning, Nor Should It

  Posted on Nov 15, 2022 at 10:48 AM

  I used to always add dtUpdated columns in all my tables too, but did not usually show that to users. However, in recent years, I don't add that column automatically to tables anymore, because I noticed that just having an update date was not very helpful to me. Now if a table is going to hol... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Jul 3, 2012 at 5:34 PM

  @Chris, I would certainly not recommend using named locks to lock session variables. A named lock will lock that section of code for all users, not just the single users session. That kind of locking strategy, particularly the exclusive lock will only serve to slow down your application during hea... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Sep 2, 2011 at 3:14 PM

  @Kumar, Assuming that after you changed it, you hit a page on the app with the "url.reset" variable, or restarted CF to that the onapplicationstart function got run again, then I don't see anything wrong based on what you have written. It's kind of difficult to debug this kind of stuff wi... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Sep 2, 2011 at 2:38 PM

  @Kumar, also (although it looks like your error is not really directly related to your cflock tag) I would highly recommend you read through this whole article and it's comments, and make sure that you even need cflock around this application variable. If a race condition happens to occur on that v... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Sep 2, 2011 at 2:30 PM

  you said you have this in OnApplicationStart: <cfset EOL=Application.EOL> My best guess (without seeing your actual code) would be that is the problem since it is not setting Application.EOL to something. it should probably be like: <cfset Application.EOL="somevalue">... read more »

• DreamWeaver CS3 Slows Me Down

  Posted on Nov 21, 2008 at 5:26 PM

  @David, >>"God, Adobe needs a new IDE." it is on it's way.... http://labs.adobe.com/wiki/index.php/Bolt... read more »

• Object Oriented Programming And ColdFusion - What's The Point?

  Posted on Oct 28, 2008 at 12:32 PM

  @Chirsopher, As I mentioned in my last post I use some "OO-ish" principles in my programming style, and I have developed CFCs to create "objects" for certain parts of applications when I think they are appropriate similar to your google api example, and instantiate the object into a memory scope to... read more »

• Object Oriented Programming And ColdFusion - What's The Point?

  Posted on Oct 27, 2008 at 6:22 PM

  As one of the people who sent Ben and email asking "What's the point?", I am happy he wrote this post. I didn't ask "What's the point?" because I think OOP is bad, but I wanted to hear from someone who had put for the effort to learn OOP to see if there is something I am missing, and to evaluate wea... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Jul 14, 2008 at 10:19 PM

  @Allen, I agree with Ben that some examples would be helpful in validating your point. There have been several occasions where a new client comes to me because their business began to boom and the increased traffic on their site caused everything to come to a screeching halt because the original pr... read more »

• DreamWeaver CS3 Slows Me Down

  Posted on Apr 24, 2008 at 2:34 PM

  Hi, My name is Scott, and I use HomeSite+.... I have tried several times to be "cool" and switch to CFEclipse and Dreamweaver, but the major problem for me there is I am a big RDS user, and the RDS implementations for both CFEclipse and Dreamweaver are just not as good as HomeSite. I am constantly ... read more »

• Thoughts On Storing Duplicate / Calculated Data In The Database

  Posted on Apr 2, 2008 at 5:14 PM

  @Ben, In regards to your "Order" scenario, I would definitely not have an "is_shipped" column and a "Date_Shipped" column. But I do typically have an status_id column that is has a foreign key to an "oder_status" table which would contain all the possible states that an order could be in. So if I ... read more »

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

  Posted on Mar 27, 2008 at 2:03 PM

  @Tom, That makes sense, and is how I use cfqueryparam. If I have the query: SELECT FirstName, LastName FROM People WHERE Active = 1 I would usually write it like: SELECT FirstName, LastName FROM People WHERE Active = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="1"/> But that quote was... read more »

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

  Posted on Mar 27, 2008 at 1:26 PM

  Hey Ben, these are all great tips! But I am not really clear on what you are saying with the statement: "In fact, even if you have a query that does NOT have any dynamic filtering, throwing in a (1 = <cfqueryparam value="1" />) in the WHERE clause will actually create a performance gain." d... read more »

• Been Very Stressed Lately

  Posted on Mar 19, 2008 at 2:24 PM

  I feel your pain, because I'm in the same boat! I've only made 2 entries on my blog this month. I've been swamped at my day job, and swamped with some consulting/moonlighting projects I've been working on. I haven't even played a video game in over 2 months. I'm hoping things simmer down soon. Han... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Jan 21, 2008 at 5:19 PM

  @Rick If you use the Duplicate() method to copy a struct that is in your application scope into the request scope or the local variable scope, then the server will indeed have to allocate memory to hold that structure for the life of each request that uses it. The benefit you would get is not to re... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Jan 16, 2008 at 2:54 PM

  @Tony, My response got too long and is a little off topic for this post so I posted it here: http://www.coldfusionguy.com/ColdFusion/blog/index.cfm/2008/1/16/Best-Practices... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Jan 15, 2008 at 11:57 AM

  @Tony, We covered that scenario in the comment posted by Mark B on Jan 14, 2008 at 4:41 PM and my response in the comment posted by me on Jan 14, 2008 at 6:14 PM. I agree if you are not going to bother locking or re-scoping your application.DSN, it would be fine to do it that way, but the differe... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Jan 14, 2008 at 7:30 PM

  @Elliot, I'm not sure what you mean by "using things like CFCs for the DSN "? How could you use a CFC for a DSN, and when would you do that?... read more »