Microsoft Index Server

[Bob Morris]

I'm not sure this is the right place for this post but here goes.

Using ADO we can obtain a dataset from Index Server using an OLEDB type
connection. The query language is a subset of SQL but I cannot find any
document that defines just how "sub" the subset is. Certainly the "BETWEEN"
keyword is not supported, and dates only seem to work if submitted as
yyyy-mm-dd. I can't seem to make SELECT COUNT(*) ... work although the same
query with a field list works as in "SELECT this, that, the other ...." and
all else the same. Finding out by trial and error is a bit tedious and if
anybody can point me at some literature I'll be grateful.

Bob

 

[William Ryan]

I haven't found between, but I can't be sure that it's not available (if it
is though, I haven't been able to make it happen either). These links were
helpful to me...hopefully they'll help you too.

http://www.ktu.lt/query_index_server_c/ixqLang.Htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/ixqlang_2rxv.asp

 

[Bob Morris]

Thanks very much. Let me digest this lot and see how I get on.

Best Regards
Bob