You will have to excuse me, I just now remembered to check this list.

Well, first of all, your message said something about using a stored
procedure to access IIS indexing data.  From what I can tell, this is
all VB or VBScript code.  I don't see any stored procedure info in here.

I must admit, I have not tried to do what you are doing.  But on first
look, if you are trying to access the IIS Indexing data via SQL Server,
you would need to do this via a Linked Server.

First step for me is to get the linked server working for IIS.  Looks
like to do that, I must install OLAP on this server.

I don't think I will try this tonight, I just finished my first cocktail
and am ready to go out and meet some friends for a later happy hour.

Let me look at this more tomorrow.

Let me just clarify that you really want a SP to handle as much of this
as possible?

Mike

-----Original Message-----
From: portals@a... [mailto:portals@a...]
Sent: Thursday, June 28, 2001 3:26 AM
To: IIS_Applictaions
Subject: [iis_applications] RE: Using stored procedure for indexing
server search

hi MM,
 thanks for your reply...
  I am giving you a little part of my code for you
  to get full idea.............
here is the code..........*************
        titles =3D trim(replace(reqest,"+"," "))
        prefixs=3D" "
        whereclause =3D ""
        whereclause1 =3D ""
        whereclause2 =3D ""
        if keywords <> "" then
                whereclause =3D prefixs & "CONTAINS(DocTitle,'" & 
Chr(34)
&
titles & Chr(34) &"') AND CONTAINS(DocKeywords,'" & Chr(34) & keywords &
Chr(34) &"') and FileName LIKE '%.htm%'"
        end if
        if titles <> "" then
                whereclause1 =3D prefixs & "CONTAINS(DocKeywords,'" & 
Chr
(34) & keywords & Chr(34) &"') AND NOT CONTAINS(DocTitle,'" & Chr(34) &
titles & Chr(34) &"') and FileName LIKE '%.htm%'"
        end if
        if contains <> "" then
                whereclause2 =3D prefixs & "CONTAINS(Contents,'" & 
Chr(34)
&
contains & Chr(34) &"') AND NOT CONTAINS(DocTitle,'" & Chr(34) & titles
&
Chr(34) &"') AND NOT CONTAINS(DocKeywords,'" & Chr(34) & titles &
Chr(34)
&"') and FileName LIKE '%.htm%'"
        end if
        dim scp
        scp =3D "/htmlasp/"
'//Set property for description and create the view and query it//
        querys =3D "SET PROPERTYNAME
'D1B5D3F0-C0B3-11CF-9A92-00A0C908DBF1'
PROPID 'description' as Descprop TYPE DBTYPE_STR;SET
PROPERTYNAME 'D1B5D3F0-C0B3-11CF-9A92-00A0C908DBF1' PROPID 'framesub' AS
Frameprop TYPE DBTYPE_STR; CREATE VIEW #Views AS SELECT
VPath,DocTitle,FileName,Path,Descprop,DocKeywords FROM
server.amdavad..SCOPE('" & Chr(34) & scp & Chr(34) &"'); SELECT * FROM
#Views "
        querys1 =3D querys
        querys2 =3D querys
'// making the query with the where caluse and selecting required
properties manucat catalog
        if whereclause <> "" then
                querys =3D querys & "where " & whereclause & "order by
DocKeywords"
        end if
        if whereclause1 <> "" then
                querys1 =3D querys1 & "where " & whereclause1 & "order 
by
DocKeywords"
        end if
        if whereclause2 <> "" then
                querys2 =3D querys2 & "where " & whereclause2 & "order 
by
DocKeywords"
        end if
        dim results, results1, results2
        dim rc, rc1, rc2
        rc =3D 0
        rc1 =3D 0
        rc2 =3D 0
        results =3D ""
        results1 =3D ""
        results2 =3D ""
        set resultset =3D server.CreateObject("ADODB.Recordset")
        set resultset1 =3D server.CreateObject("ADODB.Recordset")
        set resultset2 =3D server.CreateObject("ADODB.Recordset")
*****Here i query the Indexing service thrice in the same asp page******
        resultset.Open querys,"Provider=3DMSIDXS;"
        resultset1.Open querys1,"Provider=3DMSIDXS;"
        resultset2.Open querys2,"Provider=3DMSIDXS;"
********Then i use these three resultsets one by one in the same manner
given below and append the results form these three
resultsets***********
if not resultset.EOF then
        while not resultset.EOF
        if resultset("DocTitle") <> "" then
                results =3D results + resultset("DocTitle") + "~"
                results1 =3D results1 + resultset("VPath") + "~"
            if resultset("Descprop") <> "" then
                results2 =3D results2 + resultset("Descprop") + "~"
            else
                results2 =3D results2 + "No Description" + "~"
            end if
        end if
                resultset.MoveNext
        wend
        rc =3D 1
else
        rc =3D 0
        response.write("No Keywords and Title")               
end if
***********END OF CODE**********
But the problem is it works in Intranet finely but on
internet just one query gets called and the rest of two
queryies give ZERO results
thanks in advance.......
MANAV
> I think we would need a bit more information to be able to help.
>
> Are you saying you have an asp page that calls a sp 3 separate times,
or
> 3 separate sp's each once?