MS Indexing Server and ADO problem...

dikkjo · July 4th, 2003, 11:11 AM

Hello,

I'm working on a multi-languages site on Windows 2003 Server that is indexed with the MS Indexing Service with his own catalog.

On every page we have the following meta tag to differentiate the language:

<meta name="language" content="xx">

(xx stands for the language: us, fr, de ...)

Here is the SQL command that I pass to the provider :

Code:

strSQL = "SET PROPERTYNAME 'd1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1' PROPID 'language' AS language TYPE DBTYPE_STR;"
strSQL = strSQL & "SELECT DocTitle, vpath, filename, size, write, characterization, language "
strSQL = strSQL & "FROM SCOPE() WHERE CONTAINS ('" & strFilter & "')"

The problem is that my property 'language' is always empty.
My goal is to use the language property in the WHERE clause..!

Am I doing all wrong?

Thanks.
davide

PS: Here is where to find this non working method...
http://msdn.microsoft.com/library/de...webov_9s13.asp

dikkjo · July 11th, 2003, 04:58 AM

Hello,

well I found the answer (if somebody care)! It was a little ago but I've forgot this post...

The property was indexed but not CACHED in the catalog..!
I'm a little ashamed, it wasn't really a so called asp_pro_code problem...

cheers,
davide

marksaunders · July 14th, 2004, 07:30 AM

Dikkjo,

Did you manage to actually test on your custom meta?

I have enabled a custom meta field called ValidFrom that represents the date in Integer format (e.g. today = 20040714) and had hoped to include the where clause in my SQL select...

SET PROPERTYNAME 'd1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1' PROPID 'ValidFrom' AS ValidFrom TYPE DBTYPE_UI8;
SET PROPERTYNAME 'd1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1' PROPID 'ValidTo' AS ValidTo TYPE DBTYPE_UI8;
SET PROPERTYNAME 'd1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1' PROPID 'title' AS title TYPE DBTYPE_WSTR;
SELECT title, ValidFrom, ValidTo, Rank, DocTitle, VPath, Filename, Characterization, Write
FROM SCOPE('DEEP TRAVERSAL OF ""{0}""')
WHERE NOT CONTAINS(VPath, '""_vti_"" OR "".config""')
AND (ValidFrom = 20040701)

I actually have a piece of content that displays the ValidFrom date as 20040701 so I know it exists and is being cached - BUT with the Bold line above in place I get no results. I've tried > and < to no avail.

I've also recompiled (unchanged) the HTMLProp DLL from Microsoft!

Any advice would be very much appreciated from anyone!!

Regards
Mark

marksaunders · July 14th, 2004, 07:41 AM

In addition, I've just noted that simply adding...

AND (ValidFrom IS NOT NULL)

only the records with the ValidFrom are being returned.

If I wrap the 20040701 in quotes I receive and error indicating that it can't be converted to a DBTYPE_UI8 as I would expect

I am absolutely at a loss as to why the value is cached, retrieved (and can be output) as an unsigned integer, but when tested against it fails!

joanchew · September 7th, 2004, 11:05 PM

Hi,

May I know how can I rescan the catalog with Indexing Service after I've cached the properties?

Regards,
Joanne