John Duu wrote:
[...]
> I set up a test using sql3lite & mysql. Both responded the same way.
Can I see your test code?
>
> Look like 'NULL' in the IN clause is a reserve word. For a string
> literal NULL, you'll have to quote it.
>
> So WHERE (defects.org IN ('NULL')) selects nil
>
> and WHERE (defects.org in ('"NULL"')) select the literal "NULL".
I'd be surprised. '"NULL"' should represent a 6-character string
beginning and ending with a double-quote character, not the 4-character
string just consisting of N, U, L, L.
Best,
--
Marnen Laibow-Koser
http://www.marnen.org
[email protected]
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
