Hmm, thanks. I'll check that out. Jamie
On Mon, 25 Feb 2002 17:25:07 -0000, in cf-talk you wrote: >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/pro dte >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, >>> >>> >> >> > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
