Rick Hopper

Recent Blog Comments By Rick Hopper

• OOPhoto - Handling Database Transactions With Ease

  Posted on Aug 5, 2008 at 9:59 PM

  @Ben, That seems like a great idea. I too am trying to get a handle on the OOP approach, and a few weeks ago I encountered the Transaction issue. I had a transaction in my method which worked fine when the method was the only action I was calling from my code. When I later called that method a... read more »

• OOPhoto - Modeling The Domain In Steps (Round IV)

  Posted on Jul 15, 2008 at 5:25 PM

  @Peter, Thanks. So would it be appropriate then if I createe variables.instance.AddressID to store the address, but then had Person.GetAddress() return an Address object? In that case, I suppose the GetAddress() method would simply use the variables.instance.AddressID value and pass it into the A... read more »

• OOPhoto - Modeling The Domain In Steps (Round IV)

  Posted on Jul 15, 2008 at 5:05 PM

  @Elliott, Thanks for the suggestions. I think I may have worded my thoughts incorrectly, though. (I'm not attempting OOP currently, as I'm in a "give up and wait for next time" phase. :) I think I did have some code passing around IDs (as arguments to method calls). I guess what I'm referring t... read more »

• OOPhoto - Modeling The Domain In Steps (Round IV)

  Posted on Jul 15, 2008 at 4:17 PM

  "However, I am so nervous to touch IDs in OOP because I keep thinking that that violates the OOP ideals (shouldn't I be passing objects rather than IDs)." @Ben, I totally agree! Whenever I try doing OOP, I get caught up thinking I need to do it "the right way." And I'm fine until I start encount... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Jan 24, 2008 at 4:38 PM

  @Scott/@Ben, Thank you both for your thoughts, particularly on locking the object methods instead of the objects themselves. Rick... read more »

• CFLock And Negative Outcomes - Think It Through

  Posted on Jan 21, 2008 at 3:34 PM

  When researching locks, I've come across the technique of locking the shared variable while assigning it to a local variable and then simply using the local variable to limit the amount of code being locked. However, I have a question about how this affects complex variables. If I use this method ... read more »

• Getting Only The Date Part Of A Date/Time Stamp in SQL Server (Revisited)

  Posted on Sep 21, 2007 at 9:41 AM

  With your original method, you did the conversion using numeric dates instead of strings - not surprising given that you usually like to deal with dates as numbers. ;-) Do you know if using numeric values is inherently faster than using strings? I've done this before by converting to a varchar and... read more »