Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with:

dcs

Member since Dec 11, 2008

Recent Blog Comments By dcs

  • Using ColdFusion Structures To Remove Duplicate List Values

    Posted on Mar 22, 2013 at 9:31 AM

    Late to the party but figured I would add my two cents anyway. How about a way to count the occurrences of each value in the list, before or during the conversion to a struct key list? I would imagine that one would use listValueCount() (or listValueCountNoCase()), e.g.: <cfset objMovies[ ... read more »

  • ColdFusion CFQueryParam Binding vs. SQL Execution

    Posted on Oct 21, 2010 at 11:13 PM

    @Ben, It may be possible to clear a single cached query now - I'm not sure. (There is a quick-and-dirty way of doing it -- making a small change to the SQL -- but I don't think that was what you had in mind. :)) However, even if you have to clear all your cached queries, this is no worse than hav... read more »

  • ColdFusion CFQueryParam Binding vs. SQL Execution

    Posted on Oct 20, 2010 at 10:47 PM

    @Ben et al., Cached queries are absolutely pure gold. They're what you want to use when (a) you have a lot of memory (they take up space in memory, after all) and (b) you have a set of data that doesn't change frequently or that doesn't need to be real time. For example, suppose you're writing a fr... read more »

  • Learning ColdFusion 9: IsNull() And Working With NULL Values

    Posted on Aug 2, 2010 at 4:47 PM

    Ultimately, it looks like ColdFusion 9's new IsNull() method is nothing more than a short-hand notation for StructKeyExists(). Pardon me for being so late to the discussion - and I apologize if the point has already been covered - but I believe isNull() is slightly more awesome than structKeyExist... read more »

  • Testing ColdFusion Session Cookie Acceptance

    Posted on Mar 1, 2010 at 7:01 PM

    @Joel, You could try manually expiring the cookies on www.mydomain.com before setting them for .mydomain.com.... read more »

  • Testing ColdFusion Session Cookie Acceptance

    Posted on Feb 12, 2010 at 1:51 PM

    I don't have any insight into why it might be happening but have you tried using CFCOOKIE to set the cookies manually for the entire domain? Maybe you could put tags to do that in onSessionStart()? <cfcookie name="cfid" value="#session.cfid#" domain=".mydomain.com" /> <cfcookie name="cftok... read more »

  • Testing ColdFusion Session Cookie Acceptance

    Posted on Jan 15, 2010 at 5:59 PM

    Exactly. But it would only matter if you're also developing in (for example) JavaScript or a third-party tool that uses JavaScript. We ran into the issue with an ad server - we wanted the ad server to test for the existence of a cookie created in ColdFusion. We couldn't figure it out until we actual... read more »

  • Testing ColdFusion Session Cookie Acceptance

    Posted on Jan 6, 2010 at 7:08 PM

    @Ken, Have you already worked around the issue that CF cookies are not case-sensitive, while other cookies (such as JS cookies - I don't know about .Net cookies) are? For example, if you create a cookie called "CamelCaseCookie" in CF, CF actually creates the cookie in all-uppercase, as you will see... read more »

  • Five Months Without Hungarian Notation And I'm Loving It

    Posted on Jan 6, 2010 at 3:43 PM

    @Jason, Everything you write is perfectly true, and SQL Server has some nice tools built into it that make administering it a pretty easy task (in most cases). However Oracle does have its advantages even apart from the tired old excuse of making an investment look like it's worth it. I will say th... read more »

  • Five Months Without Hungarian Notation And I'm Loving It

    Posted on Jan 6, 2010 at 9:58 AM

    Well, Oracle does have some features that SQL Server lacks. For example, although SQL Server seems to have gotten around the silly 8060-byte limit for table rows, pages are still always 8K and extents are 8 pages or 64K, while in Oracle you can specify larger extents to ensure contiguous storage for... read more »

  • Five Months Without Hungarian Notation And I'm Loving It

    Posted on Jan 6, 2010 at 12:22 AM

    @Ben, Yes, it is a bit crazy. And, of course, if you want to find anything out about a table in Oracle by querying Oracle's system views, you have to put the table name in all-uppercase (since comparisons in SQL queries are case-sensitive)! @Jason, The 30-character limit is really absurd in this ... read more »

  • ColdFusion CFQueryParam Binding vs. SQL Execution

    Posted on Jan 5, 2010 at 11:58 AM

    That kind of performance difference is odd and goes beyond my understanding of SQL optimization mechanisms. Mine too - thankfully we have a DBA who can look at the access paths and make adjustments accordingly.... read more »

  • Five Months Without Hungarian Notation And I'm Loving It

    Posted on Jan 5, 2010 at 10:16 AM

    We use "_" in Oracle since all object names (including table names and column names) are all-uppercase by default (unless you wrap double-quotes around them). For example, if I do: create table FooBar (etc.) in Oracle, then a table named "FOOBAR" is created. Now, in some cases this might be OK. Bu... read more »

  • Five Months Without Hungarian Notation And I'm Loving It

    Posted on Dec 16, 2009 at 9:44 PM

    I used CamelCase and headlessCamelCase back when I worked on SQL Server - the former for table names, the latter for column names. So I used it in ColdFusion as well just for consistency's sake. But now that I work primarily on Oracle, I find the underscore indispensable (Oracle table- and column na... read more »

  • ColdFusion CFQueryParam Binding vs. SQL Execution

    Posted on Dec 16, 2009 at 9:38 PM

    I'm not a ColdFusion developer, I'm the Oracle DBA. I work with 3 Cold Fusion Developers. I can extract the query out of ColdFusion, run it in pl/sql developer and it returns in about 15 seconds. We recently had a similar issue on one of our ORACLE servers and it turned out to be one of the initia... read more »

  • Ask Ben: Ending ColdFusion Session When User Closes Browser

    Posted on Oct 15, 2009 at 10:33 AM

    Yes, if you expire the cookies (as shown a couple of posts above) a new session will be created. Don't delete the keys from the session scope, however: <!--- What NOT to do ---> <cfset structDelete(session, "CFID") /> <cfset structDelete(session, "CFTOKEN") />... read more »

  • Ask Ben: Ending ColdFusion Session When User Closes Browser

    Posted on Oct 15, 2009 at 8:55 AM

    Neither on a new tab or a new window, because the cookies (both the CFID and CFTOKEN persistent ones and the JSESSIONID memory-resident one) will still be accessible to the browser.... read more »

  • Ask Ben: Testing The Existence Of A Query Column In CFScript

    Posted on Sep 24, 2009 at 9:40 AM

    The answer is so easy that I wonder if that's what the original author actually meant, and that perhaps Mr. Mejia is on the right track. However, the original author did ask for a CFSCRIPT solution, which would require running a query in a CFSCRIPT block. This is easy in CF9 with the Query.cfc objec... read more »

  • Ask Ben: Ending ColdFusion Session When User Closes Browser

    Posted on Aug 18, 2009 at 8:41 PM

    I have never used J2EE session variables. Does that force a session-only cookie by default? Or is something more complicated going on behind the scenes? Regular ColdFusion sessions are identified by persistent cookies, CFID and CFTOKEN; while J2EE sessions are identified by a cookie, JSESSIONID, t... read more »

  • ColdFusion CFQueryParam Binding vs. SQL Execution

    Posted on Jun 5, 2009 at 1:37 PM

    Hmmm, well, as a practical matter I would just avoid using CFQUERYPARAM for that query - just make sure you verify your parameters to avoid SQL injection (which isn't as much of a problem with Oracle as it is with SQL Server anyway).... read more »