Latest builds not appearing

[Pav Lucistnik]

Michael L. Hostbaek píše v po 12. 09. 2005 v 15:32 +0200:
> Pav Lucistnik (pav) writes:
> > in TinderboxDS.php in getBuildsDetailed():
> > 
> > WHERE Last_Built IS NOT NULL
> > 
> > I'm not sure how Postgre works with NULL values, can someone confirm me
> > this will not work in Postgre?
> 
> Works fine:
> tinderbox=> select count(*) from ports where port_comment is NULL;
>  count 
> -------
>      0
> (1 row)
> 
> tinderbox=> select count(*) from ports where port_comment is not NULL;
>  count 
> -------
>    108
> (1 row)

No idea then. Put in the echo $q and try to spot bug in the query.

-- 
Pav Lucistnik <pav at oook.cz>
              <pav at FreeBSD.org>

Me go and see Elves and all! Hooray!
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: This is a digitally signed message part
Url : http://www.marcuscom.com/pipermail/tinderbox-list/attachments/20050912/eb14622d/attachment.bin