Archived from groups: microsoft.public.windowsxp.basics (
More info?)
David, What do you think sql stands for if you think you can have a SQL
program unless you're talking about PL/SQL which is generally identified by
..pks & .pkb extensions. I'm talking about SQL. (It's Structured Query
Language, btw. It's used for interrogating databases such as Oracle, mysql,
SQLserver etc) All developers, no matter which language they use ('though
maybe BQL is different), often need to find references to particular code
modules in other files. Using a search tool allows them to do this.
Anyway, it doesn't really matter. I was looking for some help on a specific
problems with XP's search not to get dragged into comparing technical
abilities. I've never come across BQL in the 10 years I've been working as
a certified developer for a large IT consultancy firm so I wouldn't comment
on it unless I had something constructive to say. It's always good when
people jump into a thread to give abuse but can't actually contribute any
useful advice.
"David Candy" wrote:
> I am a programmer and I know what SQL files are (although I was a BQL programmer). WTF would a user want to search them.They are a program file. They do not contain pictures of babies, resumes, sales proposals. They contain a SQL program.
>
> You are obviously an incompetent programmer with the incompetent advisers in this thread.
> As you have no idea of proramming perhaps you shold give it away.
>
> I can use search, you can't. 99.9999% of users can use it, you can't.
> --
> --------------------------------------------------------------------------------------------------
>
http://webdiary.smh.com.au/archives/_comment/001075.html
> =================================================
> "Scottb" <Scottb@discussions.microsoft.com> wrote in message news:E3999A33-7CB0-45FF-87ED-C010CA607835@microsoft.com...
> > David, I assume from your response you're not a programmer. An sql file is
> > actually just a text file with a different extension but it could just as
> > well be a .txt. in Windows terms, it is like a .INI file. Nothing more. It is
> > not a application file as there is no particular application that is needed
> > to open it. It really just is a text file that contains sql commands but with
> > a commonly used naming standard to identify it as such. It is just a plain
> > old text file that happens to contain sql commands and so I would expect to
> > to be searched.
> >
> > "David Candy" wrote:
> >
> >> No. It's designed to not search SQL files. Why would a user want to search program files. If you want your user to search your application files add a filter for that file type. But the user will start getting totally irrelevent hits on their searches for their documents. The SQL program supplier decided users didn't need to see the contents of the SQL files else they would have supplied a filter (or used the text filter).
> >>
> >> Older versions of windows support programers and hackers at the cost of useless results to users (99.999999% of the people that pay money to MS).
> >> --
> >> --------------------------------------------------------------------------------------------------
> >>
http://webdiary.smh.com.au/archives/_comment/001075.html
> >> =================================================
> >> "Scottb" <Scottb@discussions.microsoft.com> wrote in message news:A1459D9A-78F0-451F-8B93-2DA432942264@microsoft.com...
> >> > David, thanks for the explanation. In my scenario it is just a simple text
> >> > string ( in plain text files files (happens to be sql commands written using
> >> > notepad and saved as .sql but could be .txt for all intents and purposes)
> >> > that I am looking for.
> >> >
> >> > I search 'All or part of the file name:' - *.*
> >> > 'A word or phrase in the file'- a single word e.g. CustomersTab
> >> >
> >> > There's nothing complicated but it only finds a subset of the files I know
> >> > for sure contain this string. This exact same search works on my win2000 PC.
> >> >
> >> > I appreciate that XP's search tools is probably very clever under the covers
> >> > but if you can't rely on it bringing back 100% correct results I think it's
> >> > fair to say it doesn't work properly. Would you not agree?
> >> >
> >> >
> >> > "David Candy" wrote:
> >> >
> >> >> So users don't get lots of stupid hits when they are seaching for their documents, XP's search only search registered document files for text. So the files you want searched, if they should be searched, then the supplier of the program would have supplied a filter.
> >> >>
> >> >> XP comes with 4 filters
> >> >>
> >> >> Text (unicode or ANSI depending on the files header). Note previous versions would not find unicode text in files not marked unicode just like XP.
> >> >> HTML for IE and OE
> >> >> Office
> >> >> and Binary. Binary is the default for files not registered. This only searched properties of a file not content.
> >> >>
> >> >> So the manufacturer of the program that uses you files should have supplied a filter.
> >> >>
> >> >> The principal is that USER DATA is searched not the program's data. Search is for USERS not programmers.
> >> >>
> >> >> You can of course use any of the supplied filters on any filetpe by changing the registration (look at .txt\PersistantHandler in the registry). You can also make text the default for all files as well (Post SP1) or the default for unregistered file types (XP Gold).
> >> >>
> >> >> Windows search is very smart. The GUI interface to it is simple - basically you can type stuff in Containing Text field. It can generate abstracts of documents (but not in the UI from Start Search), do really advanced boolean and other types of queries.
> >> >>
> >> >> From Help
> >> >> There are five kinds of queries:
> >> >>
> >> >> a.. Free-text queries
> >> >> b.. Phrase queries
> >> >> c.. Pattern-matching queries
> >> >> d.. Relational queries
> >> >> e.. Vector-space queries (You can assign weighting factors to control the relative importance of terms in the ranking of results. Weights can range from 0.0 to 1.0. For example, in the vector-space query light, bulb, both terms have equal weight in the ranking of results. In the query: {weight value=.3} light, {weight value=.1} bulb,
> >> >> {weight value=.6} light bulb, the term "light" is three times more important than the term "bulb," and the phrase "light bulb" is twice as important as the term "light." If no weight is specified, Indexing Service uses a weight of 1.0 by default. For more information about term weighting, see Term weighting. )
> >> >>
> >> >> Note this is probably what does searching on MS's web site (as it was an Internet Site Search Engine before it became Windows Search).
> >> >>
> >> >> The advanced features and Help are available in Indexing Server in Computer Management under Services and Applications.
> >> >> --
> >> >> --------------------------------------------------------------------------------------------------
> >> >>
http://webdiary.smh.com.au/archives/_comment/001075.html
> >> >> =================================================
> >> >> "Scottb" <Scottb@discussions.microsoft.com> wrote in message news:CEA457B8-7A4F-4BCC-AD40-B6EC21CB26B0@microsoft.com...
> >> >> > ok, explain how it doesn't find files that I know contain a particular string
> >> >> > when it searches for it. A step by step dummy guide would be appreciated.
> >> >> >
> >> >> > "David Candy" wrote:
> >> >> >
> >> >> >> It does work idiot. It's that you and the other morons in this thread are stupid.
> >> >> >>
> >> >> >> --
> >> >> >> --------------------------------------------------------------------------------------------------
> >> >> >>
http://webdiary.smh.com.au/archives/_comment/001075.html
> >> >> >> =================================================
> >> >> >> "Scottb" <Scottb@discussions.microsoft.com> wrote in message news:928D713C-1A27-4788-9D21-B9A9BE86BF41@microsoft.com...
> >> >> >> > Sharon,
> >> >> >> >
> >> >> >> > I've have downloaded Agent Ransack as suggested and it does seem to be very
> >> >> >> > good so far.
> >> >> >> > It does bother me a bit still that XP's search tool doesn't always work now
> >> >> >> > when I've used the built-in search tool in several different versions of
> >> >> >> > windows for years and never had any problems. It did cause me several hours
> >> >> >> > of worry that I'd been working on old versions of code. Nevermind, I'll just
> >> >> >> > use agent ransack from now on.
> >> >> >> >
> >> >> >> > Thanks
> >> >> >> >
> >> >> >> > Scott
> >> >> >> >
> >> >> >> > "Sharon F" wrote:
> >> >> >> >
> >> >> >> >> On Wed, 20 Jul 2005 07:20:03 -0700, Scottb wrote:
> >> >> >> >>
> >> >> >> >> > Hi, I've just read through this thread as I've got a very similar, but
> >> >> >> >> > slightly different problem which is probably caused the same thing. I have
> >> >> >> >> > multiple files I know contain a certain string but only some of them are
> >> >> >> >> > found. I have followed the advice you've suggested i.e. disable the
> >> >> >> >> > indexing,but without success. The exact same files are on my other PC which
> >> >> >> >> > runs win2000 and the exact same search finds all of the files. Any ideas?
> >> >> >> >> >
> >> >> >> >> > Thanks in advance
> >> >> >> >> >
> >> >> >> >> > Scott
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >> You can edit each file type that you want included in the text search or
> >> >> >> >> use a nice little tool that MVP Doug Knox has created that does it
> >> >> >> >> automatically for you:
> >> >> >> >>
http://www.dougknox.com/xp/utils/xp_filefilter.htm
> >> >> >> >>
> >> >> >> >> Or use an alternative find tool such as Agent Ransack from
> >> >> >> >> www.mythicsoft.com
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Sharon F
> >> >> >> >> MS-MVP ~ Windows Shell/User
> >> >> >> >>
> >> >> >>
> >> >>
> >>
>
Facebook
Twitter
Instagram