Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: help using sql query against index server


Message #1 by "Eric Van Camp" <eric@a...> on Thu, 9 May 2002 10:34:10 +0200
I execute the following query and get each time this error:
OS: win nt sp6a
index server
catalog=apeiron
******************querystring+ error*********
Select DocTitle, vpath, path, filename, size, write, characterization from
(TABLE apeiron..SCOPE()) where Contains(DocAuthor, '"Van Camp"')>0 and
contains('"selfsite"')>0 order by rank desc
Microsoft OLE DB Provider for Microsoft Index Server error '80040e14'

Incorrect syntax near ). Expected _UNION. SQLSTATE=42000

/search/advsqlq.asp, line 288
**********************end*******************************
the querystring is a response.write selectstring...so i know this is the
exact querystring that is triggered, but i can not find out where the
problem is...
please help!


Eric Van Camp


  Return to Index