IIS Index Server - Dates don't display in search

This is Interesting: Free IT Magazines  
Home > Archive > IIS Index Server > February 2004 > Dates don't display in search





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Dates don't display in search
yf2001usa

2004-02-27, 3:34 am

Hi all,

I tested some code with index server on my Windows XP machine and it
displayed the dates fine and i could search on it without problems.

No i've create the real code and tried running it on the Windows 2000
Advanced Server but i keep running into the same problems.

1. I can't compile the htmlprop.dll file.
If i run nmake i get this error: makefile(17) : fatal error U1083:
target macro '' expands to nothing

2. If i use the htmlprop.dll i got from Microsoft. The dates don't
display when i search and i can't search on the dates.

I put the .dll in the winnt\system32 directory
of my Windows 2000 Advanced Server. I also put the .ini file in the
winnt\system32 directory and registered the .dll file.

..ini file:
[Names]

omroep (DBTYPE_WSTR) = d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1 omroep
categorie (DBTYPE_WSTR) = d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1
categorie
uitzenddatum (VT_FILETIME) = d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1
uitzenddatum
titel (DBTYPE_WSTR) = d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1 titel

After this i opened the excisting catalog in Index Server. Did a full
rescan and set the properties with the above settings. I set the
Storage Level to Primary. Then stopped Index Server, emptied the
catalog en started Index Server.

But after all that i still can't view uitzenddatum in my search
results.

I Use the following code to query Index Server:
Sub executeQuery(query, catalog, maxAantal, welkeKolomen, sortOrder)
objQuery.Catalog = catalog
objQuery.DefineColumn "omroep (DBTYPE_WSTR) =
d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1 omroep"
objQuery.DefineColumn "categorie (DBTYPE_WSTR) =
d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1 categorie"
objQuery.DefineColumn "uitzenddatum (VT_FILETIME) =
d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1 uitzenddatum"
objQuery.DefineColumn "titel (DBTYPE_WSTR) =
d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1 titel"
objQuery.Query = Server.HTMLEncode(query)
objQuery.Columns = welkeKolomen
objQuery.MaxRecords = maxAantal
objQuery.SortBy = sortOrder
objQuery.LocaleID = objUtility.ISOToLocaleID("EN-US")

On Error Resume Next 'Met Error check

Set Records = objQuery.CreateRecordSet("nonsequential")

If Err.Number <> 0 Then 'Er is een fout
ErrorNumber = Err.Number
ErrorDescription = Err.Description
Err.Clear
Exit Sub
End If

End Sub

And this code to show all colums:
Do While Not Records.EOF
response.Write("-----------------------------------------------<br>")
For Each objField in Records.Fields
Response.Write "<b>"
Response.Write objField.Name
Response.Write ":</b> "
Response.Write Records.Fields(objField.Name)
Response.Write "<br />"
Next
response.Write("-----------------------------------------------<br>")
Records.MoveNext
Loop

It displays all the field-names and almost all the field-values except
that the value of uitzenddatum.

I got no problem with all other fields but date fields won't work at
all. Can someone help me.
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com