[Apc-aa-coders] Re: Expiry Dates

[Mitra <mi...@ea...>]

Any comments?

- Mitra


At 8:09 PM +1100 27/3/03, Mitra wrote:
>A bug in something I did with RSS feeds has shown up a different bug 
>that I think needs fixing - but I'm not sure .....
>
>If expiry_date is NOT set, for example because its not made required 
>in the fields, then various things break,
>specifically the Item_Manager wont display any item where expiry_date is null,
>
>This is because it does a select .... where  expiry_date > '$now'
>
>This fails if there is no expiry_date, or no publish_date  with 
>Active count showing a number, but nothing appear in Item Manager
>
>Unfortunately , the reverse is not true, so ..... NOT (expiry_date < 
>'$now')    also fails.
>
>I've changed it in item_manager to   expiry_date > $now OR 
>expiry_date IS NULL  which works fine, but haven't committed to CVS.
>
>There are other places where expiry_date is tested against now 
>specifically  for example ...
>
>getxml (and I can't figure out what its doing here)
>searchlib - I think i can figure this out
>util.php3:GetItemHeadlines
>mailman , not clear whats happening here
>
>and lots more ....
>
>Any comments - does this need changing, ideally people could change 
>it in their own code to save me breaking code I'm not familiar with.
>
>- Mitra
>
>
>--
>Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
>02-6684-8096  or 0414-648-0722
>
>Life is a Mystery to be Lived, not a Problem to be Solved


-- 
Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
02-6684-8096  or 0414-648-0722 

Life is a Mystery to be Lived, not a Problem to be Solved