Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Mark Mcaulay
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Mark Mcaulay@mcaulay )

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 »

  • 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 »

  • 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 »

  • ColdFusion CFQueryParam Binding vs. SQL Execution

    Posted on Jun 5, 2009 at 11:43 AM

    Have you tried running the query in ColdFusion without CFQUERYPARAM? That would give you more information as to whether CFQUERYPARAM is the actual cause.... read more »

  • ColdFusion CFQueryParam Binding vs. SQL Execution

    Posted on May 6, 2009 at 9:41 AM

    There are performance gains associated with CFQUERYPARAM if the underlying DBMS supports bind variables and the query statement is executed multiple times. For example, if you use bind variables in Oracle, it will check to see if there is an existing execution plan for the SQL statement, whereas if ... read more »

  • ColdFusion CFQueryParam Binding vs. SQL Execution

    Posted on Apr 6, 2009 at 5:03 PM

    Re: Clearing the query cache - set the max number of cached queries in CF administrator to zero. I don't think you even have to reload the page once you do this, though I generally do to make certain. I find this a heck of a lot easier than making edits to my queries (I am picky about whitespace) ev... read more »

  • Getting The Requested URL From The Page Request Object (Servlet) Without Using CGI

    Posted on Jun 23, 2008 at 10:50 PM

    I tried using this for a CF custom 404 page and instead of returning the URL that occasioned the 404 error it returned the URL of the 404 page itself (even though that is not what is displayed in the browser)! Currently I am using CGI.query_string in order to return the errant URL but this solution ... read more »

  • Ask Ben: Converting a Query to an Array

    Posted on Jun 20, 2008 at 8:48 AM

    Yes, if you need to dynamically access the columns. Couldn't one also use the evaluate() function to dynamically access the columns? E.g., <cfset temp = evaluate("MyQuery.#variables.col#[#index#]")> IIRC, inside a CFLOOP or CFOUTPUT of MyQuery one would only need to do the following: <... read more »