Re: Index Server Script issue: VPATH is not returning anything

Mike,

I have found that I cannot include both VPath and URL in the same result
set. If both are included in the select, only the one that is last in the
qery statement will be returned. The same might be occuring for "path".

For example:

SELECT Filename, url, VPath from SCOPE() ...

will return just filename and VPath, whereas

SELECT Filename, VPath, url from SCOPE() ...

will return just filename and url.

Strangely, it doesn't fail on the query, but only when trying to bind the
results to the display column. So if the datagridview doesn't include a
reference to the non-returned column, the rest of the statement still seems
to operate OK.

This would indicate that the query syntax isn't at fault (at least
strictly), but that something internal to the Index Server producing the
results doesn't allow both to be returned.

Anyone else notice this?

Al


"MikeD" <mike_dips@xxxxxxxxxxx> wrote in message
news:A300A89A-ED12-419B-B262-766DBFBD3C2F@xxxxxxxxxxxxxxxx
I can display the path but not vpath.
I tried
Response.write "<b>VPath:</b> " & oRS("Vpath") & "<br>"

in never works on me.

Also on my catalog\directories, the icon is a folder icon and not a globe
icon. How can I make it to show globe icon so that VPATH will display?


.

Relevant Pages
Loading