Twitter Feed

Xataface Maillist

Sign up to receive the Xataface news letter with weekly updates and development tips.

 

Using Xataface to search for NULL

Posted by noreply@blogger.com (Fong Chun Chan) on Nov 7, 2008
See Original Post
If there is a row in a table that contains a NULL value, you can use Xataface to search specifically for that record but it's not as trivial as searching for NULL. You have to set it to an equal sign which will basically look for exact matches to nothing. For example:br /br /blockquote$temp_types = df_get_records_array('n1_tire_types', array('-limit'=200, 'parent_id' = "="));/blockquotebr /br /Will look for columns in the n1_type_types table with a parent_id of empty or NULL.
Read more...
Powered by Xataface
(c) 2005-2010 All rights reserved