Pivotal Labs

Main menu

Skip to primary content
Skip to secondary content
  • About
  • Case Studies
  • Team
    • Executives
    • Locations
      • San Francisco (HQ)
      • Boston
      • Boulder
      • Denver
      • London
      • Los Angeles
      • New York
  • Community
    • Blogs
    • Tech Talks
    • Events
  • Careers
    • Lifestyle
    • Principles & Practices
    • Benefits
    • FAQ
    • Apply
  • Contact
    • Press Room
    • Press Releases
    • In The News
    • Press Kit
  • All
  • Labs
  • Standup
  • Tracker

Standup 8/2/2011

Nicholas Greenfield
Tuesday, August 2, 2011

Ask for Help

Ian is looking for people will experience using the “Koloa Gem”.
JT recommended to use the standard facebook widgets instead.

In SQL, how do you make a query the opposite of:

where(:name => nil) without using a magic SQL string.

Interesting Things

In SQL null is neither true or false. Be careful for searching for something when a column can have 3 states: true, false and nil. Because falsey comparisons will not work as expected. (RVA, NM)

Events

Yoga

  • 0 Shares
  • Share on Facebook
  • Share on Twitter

3 Comments

  1. raoul duke says:

    where(‘name IS NOT NULL’)

    requires you to break into stringy-SQL instead of using pure Ruby Hashes.

    —

    I think you mean the Koala gem. Which is great, btw.

    August 2, 2011 at 1:14 pm

  2. grosser says:

    Or use not-so-readable ruby:

    where(User.arel_table[:name].not_eq(nil))

    August 2, 2011 at 10:22 pm

  3. Erik Hanson says:

    We’re using Koala for all Facebook interactions at NeedFeed. Works great. Feel free to email me with questions.

    August 2, 2011 at 10:41 pm

Add New Comment Cancel reply

Your email address will not be published.

Nicholas Greenfield

Nicholas Greenfield
New York

Recent Posts

  • NY Standup: 8/1/2011
  • Standup 5/27/11
  • 5/25/11 I have a little Chutzpah for my 2nd standup blog post
Subscribe to Nicholas's Feed

Author Topics

agile (1)
  • About
  • Case Studies
  • Team
  • Community
  • Careers
  • Contact
  • Labs
  • Events

Contact Us

contact@pivotallabs.com
+1 415-77-PIVOT
TwitterLinkedInFacebook

Pivotal Tracker

Tracker is the award-winning agile project management tool that enables real-time collaboration around a shared, prioritized backlog.
Visit pivotaltracker.com >