|
Home > Archive > IIS Index Server > May 2004 > Indexing SQL Query returns an endless, infinite set of empty records.
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 |
Indexing SQL Query returns an endless, infinite set of empty records.
|
|
| Eric Phetteplace 2004-05-07, 11:02 am |
| Hello,
I have this search page I wrote and used a couple of years ago for a client.
It seems to still work for them.
Now, I am using the same code, trying to perform the search on an index on
my machine and it is not working.
I created a catalog named 'd', with one directory 'd:\' Using the "Query
the Catalog" page, I can find the one document in d:\, hello.txt.
I run the following VBScript and I do not get hello.txt in the resulting
recordset. I get an endless, infinite set of empty records.
1. What is going on here with the infinite loop? I tried using a static
cursor as a KB article suggested for a similar situation, but to no avail.
2. What is wrong with using this SQL search syntax?
Thanks for your help,
Eric
***********
strSQL = "SELECT * from D..SCOPE ('DEEP TRAVERSAL OF ""d:\""') WHERE
FREETEXT "
strSQL = strSQL & "('hello') > 0"
strSQL = strSQL & " order by Rank desc"
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.ConnectionString = "provider=msidxs;"
objConnection.Open
Set objRS = objConnection.Execute(strSQL)
If Not objRS.EOF Then
....
***********
| |
|
| > I run the following VBScript and I do not get hello.txt in the resulting
> recordset. I get an endless, infinite set of empty records.
>
> If Not objRS.EOF Then
You are remembering to do a .movenext inside your loop aren't you?
while not .eof
'do whatever
.movenext '*******
wend
I know I sometimes forget!
Stu
| |
| Eric Phetteplace 2004-05-08, 10:41 am |
| That's in there 
It's weird because the resulting recordset is an infinite loop of blank
records.
"Stu" <saet@steh.szerg> wrote in message
news:OU2$RQENEHA.2736@TK2MSFTNGP11.phx.gbl...
>
> You are remembering to do a .movenext inside your loop aren't you?
>
> while not .eof
> 'do whatever
> .movenext '*******
> wend
>
> I know I sometimes forget!
> Stu
>
>
|
|
|
|
|