Close
Glad You're Ready. Let's Get Started!

Let us know how we can contact you.

Thank you!

We'll respond shortly.

LABS
Standup 8/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

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.

  2. grosser says:

    Or use not-so-readable ruby:

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

  3. Erik Hanson says:

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

Post a Comment

Your Information (Name required. Email address will not be displayed with comment.)

* Copy This Password *

* Type Or Paste Password Here *