incomplete values on querying indexing service
Status: Alpha
Brought to you by:
chernyshevsky
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
...