IIS Index Server - Checking the value of a property OR if the propery is not cached.

Author

Checking the value of a property OR if the propery is not cached.

Mark

2004-07-16, 8:04 am

I have a query that runs and checks for the value of a cached property
called validdate.

I've registerd the HTMLProp DLL and cached etc. and this is all
working fine.

However, when add the following:

strQuery += " AND @validdate <= " ;
strQuery += fnFormatUtcDate(dteNow);

to the query I receive ONLY those files with the cached property (i.e.
I also want all files that don't have a validdate at all:

strQuery += " AND (@validdate <= " ;
strQuery += fnFormatUtcDate(dteNow);
strQuery += " OR @validdate IS NULL )";

This still only returns those files with the validdate!?!?!

I can't used = "" as the Cisso object inform me it's expecting a
date!!

Any advice would be splendid!
Mark