Menu

#1 incomplete values on querying indexing service

open
nobody
None
5
2006-10-17
2006-10-17
Anonymous
No

I tried to query the indexing service on two Windows
2003 servers with following code:

$link = oledb_open("Provider=MSIDXS;Data Source=Web;");

$sql = "SELECT Characterization, FileName, Size, Path,
DocTitle, Rank, Write FROM SCOPE() WHERE
CONTAINS(Contents, '$q') ORDER BY Rank DESC"

$res = oledb_query($sql, $link);

while($row = oledb_fetch_assoc($res)) {
var_dump($row);
}

The properties "Characterization" and "DocTitle" are
always trimmed to 17 characters when querying by php.
An ASP-example with same sql works perfectly so I
dont't think its a problem of indexing service:

Set cn = CreateObject("ADODB.Connection")
cn.ConnectionString = "Provider=MSIDXS;"
cn.Properties("Data Source") = "Web"
cn.Open
...

Discussion


Log in to post a comment.