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 the New York ColdFusion User Group (Jan. 2010) with: Clark Valberg

Ryan DeBraal

Member since Jun 22, 2009

Recent Blog Comments By Ryan DeBraal

  • Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

    Posted on Jun 23, 2009 at 6:28 PM

    This is what ended up working for me, I'll explain how I see it, and if you can tell me where my logic is incorrect I would really appreciate it...first the lump: Application files Documents by "Tags" SO theres a Document, Tag, and Document_Tag table joining them I want the user to be able to sel... read more »

  • Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

    Posted on Jun 22, 2009 at 5:55 PM

    Crap! I just rewatched the video at home (as opposed to work) and discovered that the GROUP BY needs to be inside the "inline\temp" selection, no wonder it worked perfectly in SQL Manager Studio yet returned seemingly random results in my application :) I can't gaurentee the validity of this statem... read more »

  • Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

    Posted on Jun 22, 2009 at 2:07 PM

    I am providing my statement as thanks :) I have a tblDocument, tblTag, and a tblDocument_Tag linking them - be sure to adjust the COUNT when you add, remove values to match SELECT DISTINCT doctag.dt_tagKey FROM tblDocument_Tag AS doctag INNER JOIN ( SELECT dt_tagKey FROM tblDocument_Tag AS tmp WHE... read more »

  • Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

    Posted on Jun 22, 2009 at 2:03 PM

    I forgot to mention that I did not get a unique result-set, I did have to use a DISTINCT keyword on the first SELECT SQL Server 2005... read more »

  • Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

    Posted on Jun 22, 2009 at 2:01 PM

    Absolutely wonderful! I searched online for 3 days trying to figure this out - trying combinations of ANDs, CONTAINS, etc. I highly recommend visitors watch the short video, as I didn't realize the importance of the COUNT(*) initially and excluded it. It's very clever to pull in a list matching "... read more »