# Find with null gives exception

**URL:** <https://www.ruby-forum.com/t/find-with-null-gives-exception/119672>\
**Category:** Ruby\
**Created:** [November 9, 2007, 2:11am UTC](https://www.ruby-forum.com/t/find-with-null-gives-exception/119672 "2007-11-09T02:11:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [November 9, 2007, 2:11am UTC](https://www.ruby-forum.com/t/find-with-null-gives-exception/119672/1 "2007-11-09T02:11:08Z")

</div>

this one gives me a exception. what is the syntax if i use the find  
and wnat to return records with certail column null in it.  
Rawdata.find(:all, :conditions=\>{:processed\_indicator =\> NULL })

---

<div class="post-metadata">

**Author:** ![Junkone](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e274bd/32.png) [@Junkone](https://www.ruby-forum.com/u/Junkone)\
**Post date:** [November 9, 2007, 2:15am UTC](https://www.ruby-forum.com/t/find-with-null-gives-exception/119672/2 "2007-11-09T02:15:48Z")

</div>

Junkone wrote:

> this one gives me a exception. what is the syntax if i use the find  
> and wnat to return records with certail column null in it.  
> Rawdata.find(:all, :conditions=\>{:processed\_indicator =\> NULL })

Please ask Rails questions on the Rails list. You want:  
Rawdata.find(:all, :conditions=\>[“processed\_indicator is NULL”])