Community Member Profile

dcs
Member since Dec 11, 2008

Recent Blog Comments By dcs

  • 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" /> <cfcooki... 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 act... 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... 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 wil... 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... 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 real... 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 mi... 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... 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 o... 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, "C... 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 ob... 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 cooki... 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... 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)... 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 soluti... read more »

Member Account Kinky Solutions Shop