I'm just about to start a project that needs to combine the results of a SQL
Server query with the results of an Index Server query. The basic idea is
that the user enters/selects a bunch of search criteria on a form. Most of
the criteria selected by the user will be used to select records from the
database - standard WHERE clause stuff - but the user can also enter
free-text that should be searched for in associated uploaded documents. The
documents are sitting in the file-system with file-name pointers only stored
in the database (not the document). Only records where the associated
free-text is found in the documents should be returned. I'm new to Index
Server and am wondering how is this done. Any good references/tutes?
ASP 3.0
IIS 5.0
Windows 2000 Server
SQL Server 2000
Cheers,
Alan 6 4964
There are some good references in the Index server documentation itself, or
on MSDN. I have done index queries using Oledb driver for Index server, but
not combined with SQL server.
One idea is to create a linked server from SQL Server -- not sure if this is
even possible. But if it is, then you could query them together and combine
results. http://support.microsoft.com/default...b;en-us;198493
The above article has precisely what you are looking for -- querying index
server from a SQL server. Just add another query and union the results.
--
Manohar Kamath
Editor, .netBooks www.dotnetbooks.com
"Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message
news:er**************@TK2MSFTNGP12.phx.gbl... I'm just about to start a project that needs to combine the results of a
SQL Server query with the results of an Index Server query. The basic idea is that the user enters/selects a bunch of search criteria on a form. Most of the criteria selected by the user will be used to select records from the database - standard WHERE clause stuff - but the user can also enter free-text that should be searched for in associated uploaded documents.
The documents are sitting in the file-system with file-name pointers only
stored in the database (not the document). Only records where the associated free-text is found in the documents should be returned. I'm new to Index Server and am wondering how is this done. Any good references/tutes?
ASP 3.0 IIS 5.0 Windows 2000 Server SQL Server 2000
Cheers,
Alan
Alan,
Manohar, here's an example of both a local IS for the files and UNION'ed
with SQL FTS:
use master
go
EXEC sp_addlinkedserver 'Monarch', '', 'MSIDXS', 'Web', NULL, NULL
EXEC sp_addlinkedsrvlogin 'Monarch', 'FALSE', NULL, 'abc', ''
go
-- test IS query
select * from OpenQuery(Monarch, 'Select Directory,
FileName, size, Create, Write From SCOPE() Where size <= 200')
go
-- MSIDXS combined or UNIONed with SQL FTS query...
select * from titles where contains(*, 'books')
union
select * from OpenQuery(Monarch,
'select Directory, FileName, size, Create, Write
from SCOPE() where CONTAINS(Contents,''Index'')> 0 ')
Regards,
John
"Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in message
news:#u**************@TK2MSFTNGP12.phx.gbl... There are some good references in the Index server documentation itself,
or on MSDN. I have done index queries using Oledb driver for Index server,
but not combined with SQL server.
One idea is to create a linked server from SQL Server -- not sure if this
is even possible. But if it is, then you could query them together and
combine results.
http://support.microsoft.com/default...b;en-us;198493
The above article has precisely what you are looking for -- querying index server from a SQL server. Just add another query and union the results.
-- Manohar Kamath Editor, .netBooks www.dotnetbooks.com
"Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message news:er**************@TK2MSFTNGP12.phx.gbl... I'm just about to start a project that needs to combine the results of a SQL Server query with the results of an Index Server query. The basic idea
is that the user enters/selects a bunch of search criteria on a form. Most
of the criteria selected by the user will be used to select records from
the database - standard WHERE clause stuff - but the user can also enter free-text that should be searched for in associated uploaded documents. The documents are sitting in the file-system with file-name pointers only stored in the database (not the document). Only records where the associated free-text is found in the documents should be returned. I'm new to Index Server and am wondering how is this done. Any good references/tutes?
ASP 3.0 IIS 5.0 Windows 2000 Server SQL Server 2000
Cheers,
Alan
I've been a bit slack in replying and haven't tested any of this yet but all
this talk of UNIONing is getting me worried. Basically I'm looking for JOIN
functionality, where a row of data in my Applicants table includes the
path-name to a resume and covering letter stored in the file-system. I'm
hoping to query IS for content in the documents (keyword search), JOIN these
results with the results of a normal ...WHERE xxx LIKE 'xxx' AND yyy =
'yyy'... (etc.) query of the Applicant row data itself, and then display a
row for each Applicant record that satisfied both the SQL and IS search
criteria.
I'll have a read of the references provided but thought I'd add the above in
the meantime just to make sure I haven't misrepresented what I'm trying to
do. Apologies if this is all explained in the links provided.
Cheers,
Alan
"John Kane" <jt*****@comcast.net> wrote in message
news:eZ**************@TK2MSFTNGP12.phx.gbl... Alan, Manohar, here's an example of both a local IS for the files and UNION'ed with SQL FTS:
use master go EXEC sp_addlinkedserver 'Monarch', '', 'MSIDXS', 'Web', NULL, NULL EXEC sp_addlinkedsrvlogin 'Monarch', 'FALSE', NULL, 'abc', '' go
-- test IS query select * from OpenQuery(Monarch, 'Select Directory, FileName, size, Create, Write From SCOPE() Where size <= 200') go
-- MSIDXS combined or UNIONed with SQL FTS query...
select * from titles where contains(*, 'books') union select * from OpenQuery(Monarch, 'select Directory, FileName, size, Create, Write from SCOPE() where CONTAINS(Contents,''Index'')> 0 ')
Regards, John
"Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in message news:#u**************@TK2MSFTNGP12.phx.gbl... There are some good references in the Index server documentation itself, or on MSDN. I have done index queries using Oledb driver for Index server, but not combined with SQL server.
One idea is to create a linked server from SQL Server -- not sure if
this is even possible. But if it is, then you could query them together and combine results.
http://support.microsoft.com/default...b;en-us;198493
The above article has precisely what you are looking for -- querying
index server from a SQL server. Just add another query and union the results.
-- Manohar Kamath Editor, .netBooks www.dotnetbooks.com
"Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message news:er**************@TK2MSFTNGP12.phx.gbl... I'm just about to start a project that needs to combine the results of
a SQL Server query with the results of an Index Server query. The basic idea is that the user enters/selects a bunch of search criteria on a form.
Most of the criteria selected by the user will be used to select records from the database - standard WHERE clause stuff - but the user can also enter free-text that should be searched for in associated uploaded
documents. The documents are sitting in the file-system with file-name pointers only stored in the database (not the document). Only records where the associated free-text is found in the documents should be returned. I'm new to
Index Server and am wondering how is this done. Any good references/tutes?
ASP 3.0 IIS 5.0 Windows 2000 Server SQL Server 2000
Cheers,
Alan
Since you can UNION across databases, you can JOIN as well. I don't see any
problems there.
--
Manohar Kamath
Editor, .netBooks www.dotnetbooks.com
"Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl... I've been a bit slack in replying and haven't tested any of this yet but
all this talk of UNIONing is getting me worried. Basically I'm looking for
JOIN functionality, where a row of data in my Applicants table includes the path-name to a resume and covering letter stored in the file-system. I'm hoping to query IS for content in the documents (keyword search), JOIN
these results with the results of a normal ...WHERE xxx LIKE 'xxx' AND yyy = 'yyy'... (etc.) query of the Applicant row data itself, and then display a row for each Applicant record that satisfied both the SQL and IS search criteria.
I'll have a read of the references provided but thought I'd add the above
in the meantime just to make sure I haven't misrepresented what I'm trying to do. Apologies if this is all explained in the links provided.
Cheers,
Alan
"John Kane" <jt*****@comcast.net> wrote in message news:eZ**************@TK2MSFTNGP12.phx.gbl... Alan, Manohar, here's an example of both a local IS for the files and UNION'ed with SQL FTS:
use master go EXEC sp_addlinkedserver 'Monarch', '', 'MSIDXS', 'Web', NULL, NULL EXEC sp_addlinkedsrvlogin 'Monarch', 'FALSE', NULL, 'abc', '' go
-- test IS query select * from OpenQuery(Monarch, 'Select Directory, FileName, size, Create, Write From SCOPE() Where size <= 200') go
-- MSIDXS combined or UNIONed with SQL FTS query...
select * from titles where contains(*, 'books') union select * from OpenQuery(Monarch, 'select Directory, FileName, size, Create, Write from SCOPE() where CONTAINS(Contents,''Index'')> 0 ')
Regards, John
"Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in message news:#u**************@TK2MSFTNGP12.phx.gbl... There are some good references in the Index server documentation
itself, or on MSDN. I have done index queries using Oledb driver for Index
server, but not combined with SQL server.
One idea is to create a linked server from SQL Server -- not sure if this is even possible. But if it is, then you could query them together and combine results.
http://support.microsoft.com/default...b;en-us;198493
The above article has precisely what you are looking for -- querying index server from a SQL server. Just add another query and union the
results. -- Manohar Kamath Editor, .netBooks www.dotnetbooks.com
"Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message news:er**************@TK2MSFTNGP12.phx.gbl... > I'm just about to start a project that needs to combine the results
of a SQL > Server query with the results of an Index Server query. The basic
idea is > that the user enters/selects a bunch of search criteria on a form. Most of > the criteria selected by the user will be used to select records
from the > database - standard WHERE clause stuff - but the user can also enter > free-text that should be searched for in associated uploaded documents. The > documents are sitting in the file-system with file-name pointers
only stored > in the database (not the document). Only records where the
associated > free-text is found in the documents should be returned. I'm new to
Index > Server and am wondering how is this done. Any good references/tutes? > > ASP 3.0 > IIS 5.0 > Windows 2000 Server > SQL Server 2000 > > Cheers, > > Alan > >
Thanks for the reply (again). What does IS use as a key value - is it common
to take the filename of the document as found by IS and (in my case) join
that with the value of the filename column in SQL?
Cheers,
Alan
"Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in message
news:ul***************@TK2MSFTNGP12.phx.gbl... Since you can UNION across databases, you can JOIN as well. I don't see
any problems there.
-- Manohar Kamath Editor, .netBooks www.dotnetbooks.com
"Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message news:%2******************@TK2MSFTNGP11.phx.gbl... I've been a bit slack in replying and haven't tested any of this yet but all this talk of UNIONing is getting me worried. Basically I'm looking for JOIN functionality, where a row of data in my Applicants table includes the path-name to a resume and covering letter stored in the file-system. I'm hoping to query IS for content in the documents (keyword search), JOIN these results with the results of a normal ...WHERE xxx LIKE 'xxx' AND yyy = 'yyy'... (etc.) query of the Applicant row data itself, and then display
a row for each Applicant record that satisfied both the SQL and IS search criteria.
I'll have a read of the references provided but thought I'd add the
above in the meantime just to make sure I haven't misrepresented what I'm trying
to do. Apologies if this is all explained in the links provided.
Cheers,
Alan
"John Kane" <jt*****@comcast.net> wrote in message news:eZ**************@TK2MSFTNGP12.phx.gbl... Alan, Manohar, here's an example of both a local IS for the files and
UNION'ed with SQL FTS:
use master go EXEC sp_addlinkedserver 'Monarch', '', 'MSIDXS', 'Web', NULL, NULL EXEC sp_addlinkedsrvlogin 'Monarch', 'FALSE', NULL, 'abc', '' go
-- test IS query select * from OpenQuery(Monarch, 'Select Directory, FileName, size, Create, Write From SCOPE() Where size <= 200') go
-- MSIDXS combined or UNIONed with SQL FTS query...
select * from titles where contains(*, 'books') union select * from OpenQuery(Monarch, 'select Directory, FileName, size, Create, Write from SCOPE() where CONTAINS(Contents,''Index'')> 0 ')
Regards, John
"Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in
message news:#u**************@TK2MSFTNGP12.phx.gbl... > There are some good references in the Index server documentation itself, or > on MSDN. I have done index queries using Oledb driver for Index server, but > not combined with SQL server. > > One idea is to create a linked server from SQL Server -- not sure if
this is > even possible. But if it is, then you could query them together and combine > results. > > http://support.microsoft.com/default...b;en-us;198493 > > The above article has precisely what you are looking for -- querying index > server from a SQL server. Just add another query and union the results. > > -- > Manohar Kamath > Editor, .netBooks > www.dotnetbooks.com > > > "Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message > news:er**************@TK2MSFTNGP12.phx.gbl... > > I'm just about to start a project that needs to combine the
results of a > SQL > > Server query with the results of an Index Server query. The basic idea is > > that the user enters/selects a bunch of search criteria on a form. Most of > > the criteria selected by the user will be used to select records from the > > database - standard WHERE clause stuff - but the user can also
enter > > free-text that should be searched for in associated uploaded documents. > The > > documents are sitting in the file-system with file-name pointers only > stored > > in the database (not the document). Only records where the associated > > free-text is found in the documents should be returned. I'm new to Index > > Server and am wondering how is this done. Any good
references/tutes? > > > > ASP 3.0 > > IIS 5.0 > > Windows 2000 Server > > SQL Server 2000 > > > > Cheers, > > > > Alan > > > > > >
Depends on your table definition in SQL, although file path/name would be an
obvious choice.
--
Manohar Kamath
Editor, .netBooks www.dotnetbooks.com
"Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message
news:eV**************@TK2MSFTNGP10.phx.gbl... Thanks for the reply (again). What does IS use as a key value - is it
common to take the filename of the document as found by IS and (in my case) join that with the value of the filename column in SQL?
Cheers,
Alan
"Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in message news:ul***************@TK2MSFTNGP12.phx.gbl... Since you can UNION across databases, you can JOIN as well. I don't see any problems there.
-- Manohar Kamath Editor, .netBooks www.dotnetbooks.com
"Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message news:%2******************@TK2MSFTNGP11.phx.gbl... I've been a bit slack in replying and haven't tested any of this yet
but all this talk of UNIONing is getting me worried. Basically I'm looking for JOIN functionality, where a row of data in my Applicants table includes the path-name to a resume and covering letter stored in the file-system.
I'm hoping to query IS for content in the documents (keyword search), JOIN these results with the results of a normal ...WHERE xxx LIKE 'xxx' AND yyy = 'yyy'... (etc.) query of the Applicant row data itself, and then
display a row for each Applicant record that satisfied both the SQL and IS
search criteria.
I'll have a read of the references provided but thought I'd add the above in the meantime just to make sure I haven't misrepresented what I'm
trying to do. Apologies if this is all explained in the links provided.
Cheers,
Alan
"John Kane" <jt*****@comcast.net> wrote in message news:eZ**************@TK2MSFTNGP12.phx.gbl... > Alan, > Manohar, here's an example of both a local IS for the files and UNION'ed > with SQL FTS: > > use master > go > EXEC sp_addlinkedserver 'Monarch', '', 'MSIDXS', 'Web', NULL,
NULL > EXEC sp_addlinkedsrvlogin 'Monarch', 'FALSE', NULL, 'abc', '' > go > > -- test IS query > select * from OpenQuery(Monarch, 'Select Directory, > FileName, size, Create, Write From SCOPE() Where size <= 200') > go > > -- MSIDXS combined or UNIONed with SQL FTS query... > > select * from titles where contains(*, 'books') > union > select * from OpenQuery(Monarch, > 'select Directory, FileName, size, Create, Write > from SCOPE() where CONTAINS(Contents,''Index'')> 0 ') > > Regards, > John > > > > > "Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in message > news:#u**************@TK2MSFTNGP12.phx.gbl... > > There are some good references in the Index server documentation
itself, > or > > on MSDN. I have done index queries using Oledb driver for Index server, > but > > not combined with SQL server. > > > > One idea is to create a linked server from SQL Server -- not sure
if this > is > > even possible. But if it is, then you could query them together
and > combine > > results. > > > > http://support.microsoft.com/default...b;en-us;198493 > > > > The above article has precisely what you are looking for --
querying index > > server from a SQL server. Just add another query and union the results. > > > > -- > > Manohar Kamath > > Editor, .netBooks > > www.dotnetbooks.com > > > > > > "Alan" <Xa*************@XparadiseX.XnetX.XnzX> wrote in message > > news:er**************@TK2MSFTNGP12.phx.gbl... > > > I'm just about to start a project that needs to combine the results of a > > SQL > > > Server query with the results of an Index Server query. The
basic idea > is > > > that the user enters/selects a bunch of search criteria on a
form. Most > of > > > the criteria selected by the user will be used to select records from > the > > > database - standard WHERE clause stuff - but the user can also enter > > > free-text that should be searched for in associated uploaded documents. > > The > > > documents are sitting in the file-system with file-name pointers only > > stored > > > in the database (not the document). Only records where the associated > > > free-text is found in the documents should be returned. I'm new
to Index > > > Server and am wondering how is this done. Any good references/tutes? > > > > > > ASP 3.0 > > > IIS 5.0 > > > Windows 2000 Server > > > SQL Server 2000 > > > > > > Cheers, > > > > > > Alan > > > > > > > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John |
last post by:
I currently have a list box that contains regions in the US
(Northeast, Midwest, South, etc.). I am retrieving this data from my
Region table(see below). Users have the ability to select a region...
|
by: Billy Jacobs |
last post by:
We are trying to create a search page using .net and
Microsoft Index Server. We would like to customize the
search to filter certain documents and also customize how
the results are displayes....
|
by: Robert Oschler |
last post by:
I read a while back that MySQL will only use one index per query. (If this
is not so, please tell me and point me to a doc that gives a good
explanation of MySQL's current index usage policy). ...
|
by: Kent P. Iler |
last post by:
Hi,
I am building my first ASP.NET website (I've done quite a few in ASP with
windows DNA, but none needing Index server).
I need to have a site search, and want the results formatted in a...
|
by: Kent P. Iler |
last post by:
Hi,
I have a website that I need to build that will allow the users to upload
PowerPoint files, and then search on them. I know how to upload the files,
display them, etc., but I've never used...
|
by: Chris |
last post by:
I have a simple search feature that searches 3 fields in 3 separate tables
in a MySQL db, and I'm getting an 'undefined index' error, but only in the
first section (first table)of the results. The...
|
by: rvenable |
last post by:
Hi everyone,
I'm new to this forum and I hope I'm in the right one. I have a question regarding MS Index server to search for french accent characters.
I have a search engine for our website that...
|
by: J055 |
last post by:
Hi
I need to search a number of DataTables within a DataSet (with some
relationships) and then display the filtered results in a GridView. The
Columns that need to be displayed come from 2 of...
|
by: Ken Fine |
last post by:
This is a question that someone familiar with ASP.NET and ADO.NET DataSets
and DataTables should be able to answer fairly easily. The basic question is
how I can efficiently match data from one...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |