Anthony Hixon, Jr.

Recent Blog Comments By Anthony Hixon, Jr.

• My 1,000th ColdFusion Post - What It Means To Me (And Free Prizes)

  Posted on Jan 23, 2009 at 1:26 PM

  I started with ColdFusion about 6 years ago as many others have which was just looking for a way to do dynamic web stuff. I came from a network/server management background, but I saw that my employer had a need for eliminating some paper processes. I found ColdFusion and they let me run with it to ... read more »

• Getting ColdFusion To Work With MS SQL Server Express 2005 Databases

  Posted on Dec 12, 2008 at 8:56 AM

  @Ben It seems odd to me as well. There are a few conditional functions you can use outside stored procedures ( http://snurl.com/7thwu ), but it's not the same as having the full gamut to me. Although I must say I normally use procedures when I get that complex so I'd never tried to use conditions... read more »

• Getting ColdFusion To Work With MS SQL Server Express 2005 Databases

  Posted on Dec 12, 2008 at 1:03 AM

  @Ben I'm not trying to be a poster child for MySQL or anything but when you said: "In fact, there are things about it that I like more, like having the ability to run conditional logic inbetween queries such as: IF (@id = 0) BEGIN SET @id = ( SELECT ... ); END MySQL does not allow us to do tha... read more »

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

  Posted on Dec 9, 2008 at 9:12 PM

  These are all great arguments which I have read up on before, but as Ben stated earlier, I was also "brought up" on auto-increment ID keys so I guess it's just what I'm used to. I've also used @@identity for a long time now in many applications and given that I have never had a need for triggers (... read more »