Christopher Wigginton
Member since Dec 11, 2008
- Profile: /members/823-christopher-wigginton.htm
- Comments: 14
Recent Blog Comments By Christopher Wigginton
-
Considering MySQL, CFQueryParam, Prepared Statements, And SQL Queries That Use IN Clauses In ColdFusion
Posted on Apr 6, 2020 at 8:41 AM
I think the first thing that would come to mind with a huge in clause would be to check if there was some data already in the database that would help such as "where foo_id in (select foo_id from lookup_table where category = 'something') . I'd also consider the use of # temp or ## glob... read more »
-
SQL Queries That Look The Same Are Not Violating The DRY Principle
Posted on Jun 11, 2019 at 9:16 AM
If the same query is used for multiple customers and one customer has a new requirement, you also have to take into consideration if the change will cause an unavoidable performance hit ( no matter how small) if it is worth it to make a version just for that customer. Now in the case of busi... read more »
-
Reconsidering "text-overflow: ellipsis" As A Design Smell And Accessibility Concern
Posted on May 28, 2019 at 3:00 AM
It always bugged me when I couldn't see the whole information when ellipsis are displayed. From an accessibility issue, I've always put the full description in "alt" attribute, though I think ellipsis wise it's still there, so the text reader would still get it. I also usually add... read more »
-
An Intensive Exploration Of jQuery With Ben Nadel (Video Presentation)
Posted on Feb 13, 2009 at 9:50 PM
Great job Ben! I've been using JQuery for awhile now. I started with prototype and quickly switched to JQuery. While I'm not a big fan of Microsoft, I was pleased to hear that Microsoft announced plans (Sept. 2008) to incorporate it into their Visual Studio toolset which does provide JQuery so... read more »
-
Attempting Switch To iTunes From WinAmp
Posted on Dec 11, 2007 at 4:17 PM
Don't buy audio books from iTunes. I believe that Apple made an arrangement with Audible to provide the book sales. If you sign up with Audible.com, they have a monthly plan where you essentially get 1 book a month from around $15.00 and able to buy the rest at a considerable discount. The iPod i... read more »
-
Kinky ColdFusion Calendar System Almost There
Posted on Aug 7, 2007 at 5:02 PM
Hi Ben, One suggestion; In month view, when a date has multiple entries, it isn't completely obvious, perhaps a little css hover technique to highlite individual events.... read more »
-
ColdFusion DateTimeFormat() Utility Function
Posted on May 22, 2007 at 7:47 AM
Yup, Ray did it back in 2001 and has it on his cflib.org site http://www.cflib.org/udf.cfm?ID=134 cflib.org hasn't got much press lately and it's easy to forget the wealth of udf's on the site.... read more »
-
Ask Ben: Limit File Upload Size In ColdFusion
Posted on May 2, 2007 at 10:15 AM
Just thinking out of the box, you could also consider using a web based rich text editor. This gives you a little more control on the client side for size limitation and eliminates issues of someone uploading different file formats, macro viruses and such. Some RTE's also supports word paste otpi... read more »
-
Searching Directories And File Content Using ColdFusion
Posted on Mar 1, 2007 at 4:44 PM
Why not just use Verity (or Lucene for the Blue Dragon crowd)?... read more »
-
Ask Ben: Cleaning Two Digit Years Using Javascript And Regular Expressions
Posted on Jan 26, 2007 at 9:46 AM
Having users enter a two digit year is part of the Y2K issue. A common solution for 2 year digit data was to use a pivot formula, for the below example, I set 70 as the pivot year. Easy enough to set the pivot base, depending on the type of question being asked, such as your birth date, and the... read more »
-
Parsing CSV Values Using A Standard File Format
Posted on Jan 25, 2007 at 12:09 PM
Dealing with dirty data can always throw a kink into things. If it's a one off data import, sometimes it's just easier to open the file first in Excel, expand out the columns and look for the dirty row. For continual usage, using the list functions are great, and when you have a known column count... read more »
-
Required Changes To My RSS Feed Format
Posted on Jan 23, 2007 at 4:35 PM
You could try Ray's scopecache on the main feed or make the feed static by saving the feed out to an XML file and only refreshing the file when you add a post. static files would reduce load on your database and CF server and would also provide a spider friendly URL. The only major issue I see is... read more »
-
Determining Which Function Called This Function (Using ColdFusion)
Posted on Nov 16, 2006 at 10:31 AM
You could also just dump the cf catch in the cf catch block. <cf catch> <cf dump var="#cf catch#"> </cf catch> That's assuming the original question was directed towards debugging. Let's hope the original question wasn't based on an idea of trying to build a function t... read more »