I've not done it but according to the MS site there is a filter available from Adobe that allows you to do it. http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodte chn ol/sharepoint/evaluate/featfunc/mssearch.asp -----Original Message----- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: 25 February 2002 17:04 To: CF-Talk Subject: Re: Joining Tables from Different Datasources... Possible?
>if you use MS Indexing instead of Verity You can't index binaries (PDFs) though, can you? Thanks, Jamie On Mon, 25 Feb 2002 15:51:29 -0000, in cf-talk you wrote: >Just a thought, but if you use MS Indexing instead of Verity, along with >other advantages (it's faster and self-maintaining)you can build sql >statements combining db tables and file indexes. > >-----Original Message----- >From: Jamie Jackson [mailto:[EMAIL PROTECTED]] >Sent: 25 February 2002 15:19 >To: CF-Talk >Subject: Re: Joining Tables from Different Datasources... Possible? > > >Thanks for the replies. What I am doing is attempting to join a Verity >result set on a SQL server table. The table contains abstracts, >display codes, titles etc., of PDF's that Verity has also indexed. > >Currently, to get a match, I'm using nested loops to determine >matches, and I modify the original Verity result set using >QuerySetCell. This takes quite a long time because of the nested >loops. It would be nice to do a SQL-like join instead. > >Maybe the solution is to write the Verity result set to a temporary >SQL table and then do the join. > >Recommendations? > >Thanks, >Jamie > > >On Sat, 23 Feb 2002 10:08:32 -0500, in cf-talk you wrote: > >>If you're using SQL Server, AND the databases are on separate machines, >>you >>need to LINK the databases from within enterprise manager. Then, when >>you >>reference database.dbo.tablename, SQL Server will do the rest. If I >>recall >>correctly, it is not enough to simply register the server, they must >>also be >>Linked. To link a server in SQL Server 2000, choose "new linked >>server" >>under the "security" tab for a registered server. I believe you need >>to >>make the link on both servers, but if you don't, then the DSN that you >>use >>for the "datasource" property in your CFQUERY tag will need to refer to >>the >>server that defined the active link. Oh, while I have no direct proof >>of >>this, I believe it is best to weigh the size of the tables and activity >>of >>the server when choosing which server initiates the join in your >>CFQUERY >>tag. Especially when servers are separated by thousands of miles (as >>mine >>are) it seems to make a difference to let the server with the largest >>portion of the data crunch the join. Also, for security reasons, I >>have >>been told it may not be practical to Link a server that is behind a >>firewall >>to a server outside the firewall. Rather, a one-way link from inside >>to out >>would make better sense. This might apply if your webserver runs SQL >>Server >>locally in a DMZ. >> >>Good Fortune, >>Rick Walters >>Webmaster, Davita Laboratory Services >>Office: (800) 604-5227 >>Cell: (407) 491-9848 >> >>-----Original Message----- >>From: Jamie Jackson [mailto:[EMAIL PROTECTED]] >>Sent: Friday, February 22, 2002 5:05 PM >>To: CF-Talk >>Subject: Joining Tables from Different Datasources... Possible? >> >>How would I do a join of tables from two different datasources? >> >>Thanks, >> >> > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists