Thomas

Recent Blog Comments By Thomas

• Paginating Record Sets In ColdFusion With One SQL Server Call

  Posted on Oct 17, 2007 at 11:55 AM

  @Ben Ok so some more information about this subject :) I had some tests running in our article database. Row count: 9.2 mio rows Column Type: varchar(22) (case insensitive, not unique) contains: Article Numbers (alphanumeric) index: yes (not clustered) I need to get a DISTINCT count of hits cont... read more »

• Paginating Record Sets In ColdFusion With One SQL Server Call

  Posted on Oct 17, 2007 at 8:37 AM

  @Ben don't want to become this to much offtopic, anyway: if CHARINDEX was faster, that was something i had to try instantly. I made a few example runs and was NOT able to achieve a speed advantage agains LIKE %... expression. the CHARINDEX method was about 10% SLOWER than LIKE %... expression. Whe... read more »

• Kinky File Explorer - ColdFusion And jQuery Based File Explorer

  Posted on Oct 17, 2007 at 8:23 AM

  Nice, for Image types you could simply display the image, but i am sure you already thought about it :)... read more »

• Paginating Record Sets In ColdFusion With One SQL Server Call

  Posted on Oct 17, 2007 at 7:11 AM

  Nice Article! I wonder if it would be possible to write more generic/dynamic routines. I already have such generic routines for query results, based on a query-on-queries, but of course they are very inefficient (due to the huge data amout loaded but not used). I'm thinking of a custom tag, which ... read more »

• CFCs Are Cached, CFIncludes Are Not

  Posted on Sep 26, 2007 at 12:53 PM

  @Ben exactly... The only difference is that I don't include the cffunction code (function.txt), its simply inline-/hardcoded. This means, that when you would hard-copy the content of function.txt into Cache.cfc, you would get the same behaviour. Regarding this case, your example might be irritating... read more »

• CFCs Are Cached, CFIncludes Are Not

  Posted on Sep 26, 2007 at 4:39 AM

  @Sean indeed, the root of this evil can be found in original ColdFusion Docs like this one: http://livedocs.adobe.com/coldfusion/7/htmldocs/00001148.htm The document is called: "About persistent scope variables" and lists the Client, Session, Application and Server scopes. @Ben Thanks for this... read more »

• My First jQuery Plugin

  Posted on Aug 29, 2007 at 8:53 AM

  Nice :) Just a short note, nothing special, instead of $( "input[@type='button']" ) you can use the shorter and faster selector $("input:button") as described here: http://docs.jquery.com/Selectors #Form_Selectors Quote: "Using :radio is mostly the same as [@type=radio], but should be slightly f... read more »

• ColdFusion Basics : Nesting Custom Tags

  Posted on Feb 13, 2007 at 9:01 AM

  Great work, not only on this article!... read more »