> 2 queries vs 1. i win.
Only if your one query is faster than my two!
> > whether you can do in SQL Server's text indexing, like
> > spidering sites and indexing filesystem contents (although
> > I suspect that if one knew enough ...
>
> um i win again (just call me cash money ;-)
>
> SELECT Q.DocTitle, DATEPART(YEAR, Q.Create)
> FROM OPENQUERY(FileSystem,
> 'SELECT DocTitle, Create
> FROM SCOPE('' "/pubs" '')
> WHERE BookCost <= 20.00
> AND CONTAINS( Characterization, '' "ice hockey" '' )
> ') AS Q
Well, that only works if you store the files on the local filesystem of the
database server, right? That won't help if they're somewhere else, like the
filesystem of the web server, will it?
But yes, I'll call you cash money, though!
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
