davidcl

Recent Blog Comments By davidcl

• Getting @@RowCount After SQL INSERT INTO Statement

  Posted on Jul 27, 2009 at 10:23 AM

  <CFQUERY....> declare @myvar int //do calculations on @myvar SELECT @myvar as result </CFQUERY> <cfoutput>#queryname.result#</cfoutput> That should work.... read more »

• Getting @@RowCount After SQL INSERT INTO Statement

  Posted on Nov 29, 2007 at 6:04 PM

  @Ben, That's not quite right. IDENT_CURRENT is going to be subject to returning the wrong information if there are multiple simultaneous inserts on the table. I believe that if it's in an explicit transaction, IDENT_CURRENT will be the same as @@IDENTITY in all situations, but I feel a lot more c... read more »

• CFParam And Regex-Pattern Is Quite Awesome

  Posted on Nov 19, 2007 at 10:53 AM

  I see what you're saying now. In fact I think we're in agreement about this.... read more »

• CFParam And Regex-Pattern Is Quite Awesome

  Posted on Nov 19, 2007 at 10:40 AM

  Okay, now I'm confused. I'm talking about the case when the form input doesn't match the regex. According to your previous reply, that throws an exception, which has to be caught. My comment is that I'd prefer to catch that failed validation without throwing an exception. I agree that throwing a... read more »

• CFParam And Regex-Pattern Is Quite Awesome

  Posted on Nov 19, 2007 at 10:29 AM

  Interesting. I like the idea conceptually, but as mentioned by a few commenters on your previous post, the idea of throwing an exception for a validation failure seems a little extreme (even if the exception is caught in the same tag).... read more »

• CFParam And Regex-Pattern Is Quite Awesome

  Posted on Nov 19, 2007 at 10:09 AM

  What does cfparam do if the value is defined but doesn't match the regex? Throw an error, or use the default value?... read more »