Windows Explorer search file contents not working on .sql files.



dba_222@yahoo.com
07-09-2005, 11:34 PM
Dear Experts,

I hate to have to post such a seemingly dumb question.
But all the obvious has not worked.

My new XP Pro laptop was recently configured for me.
After installing Teradata SQL Assistant, the .SQL files
were opening with that. But, that was not what I wanted
to use. In Windows, I like to use wordpad.

I work with Oracle scripts, with the suffix: .SQL.
There are hundreds of them.

Like most people, I often forget which file contains what.
So, I usually use Windows Explorer search to find the file.
If I know that the file is concerning GV$PROCESS, I just use
windows explorer to search all files for that keyword.
Usually this works fine.

But, explorer doesn't find a thing in any one of my .SQL files.
Not even the SELECT keyword, which is in almost ALL of them.

I've done the obvious. In Windows explorer.
Tools, folder Options. file types. change it to:
notepad, wordpad, and even MS Word (which usually works).

The file will open with the app that I change it to.

However, any search for the contents for the contents of files,
will always return zero files found!!!

Searching through the registry has not shown anything obvious.

What is the secret to fix this???


Thanks a lot.

Torgeir Bakken \(MVP\)
07-09-2005, 11:34 PM
dba_222@yahoo.com wrote:

> (snip)
> My new XP Pro laptop was recently configured for me.
> After installing Teradata SQL Assistant, the .SQL files
> were opening with that. But, that was not what I wanted
> to use. In Windows, I like to use wordpad.
>
> I work with Oracle scripts, with the suffix: .SQL.
> There are hundreds of them.
>
> Like most people, I often forget which file contains what.
> So, I usually use Windows Explorer search to find the file.
> If I know that the file is concerning GV$PROCESS, I just use
> windows explorer to search all files for that keyword.
> Usually this works fine.
>
> But, explorer doesn't find a thing in any one of my .SQL files.
> Not even the SELECT keyword, which is in almost ALL of them.
> (snip)
Hi,

The search function in Windows XP filters out files to search in based
on file extensions (list can be manipulated, see further below).

My suggestion:

Install the free Agent Ransack, it searches for text strings in *all*
types of files, and not just in a selection of "approved" file extensions
as the built-in search does. It's a *much* better search tool as well...

Download it from here:
http://www.mythicsoft.com/agentransack/default.aspx

Agent Ransack can save the search result to a file (or clipboard), as text,
comma separated text or tab separated text. E.g. Excel reads comma separated
text (csv) very well.

When searching for text inside files, Agent Ransack is also able to do a
preview of the lines the text was found in (just do a single click on the
found file).
Also, you can use regular expression on both the file name part and the find
text in files part.


If you still want to use the not so good search tool that comes
with WinXP to search for text in files, take a look at this:

Using the "A Word or Phrase in the File" Search Criterion May Not Work
http://support.microsoft.com/default.aspx?scid=KB;EN-US;309173

Or this:

Add Files to Containing text Searches
http://www.dougknox.com/xp/scripts_desc/xp_fix_search.htm



--
torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway
Administration scripting examples and an ONLINE version of
the 1328 page Scripting Guide:
http://www.microsoft.com/technet/scriptcenter/default.mspx

dba_222@yahoo.com
07-09-2005, 11:34 PM
Thanks a lot. This is what I did, just in case anyone
else gets the same issue.

Noted at the registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex\DllsToRegister

that there were a number of dlls to register.
Registered them. Although they remained in the same key.


Change the registry in:

HKEY_CLASSES_ROOT\.sql

Add key:

HKEY_CLASSES_ROOT\.sql\PersistentHandler


Set this value to:

{5e941d80-bf96-11cd-b579-08002b30bfeb}


Change the app to wordpad.

Reboot to be sure.

Works!



dba_...@yahoo.com wrote:
> Dear Experts,
>
> I hate to have to post such a seemingly dumb question.
> But all the obvious has not worked.
>
> My new XP Pro laptop was recently configured for me.
> After installing Teradata SQL Assistant, the .SQL files
> were opening with that. But, that was not what I wanted
> to use. In Windows, I like to use wordpad.
>
> I work with Oracle scripts, with the suffix: .SQL.
> There are hundreds of them.
>
> Like most people, I often forget which file contains what.
> So, I usually use Windows Explorer search to find the file.
> If I know that the file is concerning GV$PROCESS, I just use
> windows explorer to search all files for that keyword.
> Usually this works fine.
>
> But, explorer doesn't find a thing in any one of my .SQL files.
> Not even the SELECT keyword, which is in almost ALL of them.
>
> I've done the obvious. In Windows explorer.
> Tools, folder Options. file types. change it to:
> notepad, wordpad, and even MS Word (which usually works).
>
> The file will open with the app that I change it to.
>
> However, any search for the contents for the contents of files,
> will always return zero files found!!!
>
> Searching through the registry has not shown anything obvious.
>
> What is the secret to fix this???
>
>
> Thanks a lot.

Ian Moyce
07-09-2005, 11:34 PM
dba_222@yahoo.com wrote:

> What is the secret to fix this???
>

Pie.

Ian Moyce
07-09-2005, 11:34 PM
(MVP) wrote:
> (bollocks)

Ian Moyce RHCE, JAPH, GCSE
Project Development Manager, NSI

Twisted One
07-09-2005, 11:34 PM
Ian Moyce wrote:
> (MVP) wrote:
>
>>(bollocks)

His suggestion to use agent ransack was not bollocks. Explorer's search
is broken as designed and dangerously misleading. Score another
"brilliant" idea for Microsoft, from a long line of such ... Bob ...
paperclip ... nonstandard HTML quotes ... \ for directory separator char
.... the list goes on and on!

--
http://www.gnu.org/philosophy/right-to-read.html
Palladium? Trusted Computing? DRM? Microsoft? Sauron.
"One ring to rule them all, one ring to find them
One ring to bring them all, and in the darkness bind them."

Ian Moyce
07-09-2005, 11:34 PM
Twisted One wrote:
> Ian Moyce wrote:
>> (MVP) wrote:
>>
>>> (bollocks)
>
> His suggestion to use agent ransack was not bollocks. Explorer's
> search is broken as designed and dangerously misleading. Score another
> "brilliant" idea for Microsoft, from a long line of such ... Bob ...
> paperclip ... nonstandard HTML quotes ... \ for directory separator
> char ... the list goes on and on!

But he is still an MCP.

Twisted One
07-09-2005, 11:34 PM
Ian Moyce wrote:
> Twisted One wrote:
>>Ian Moyce wrote:
>>>(MVP) wrote:
>>>
>>>>(bollocks)
>>
>>His suggestion to use agent ransack was not bollocks. Explorer's
>>search is broken as designed and dangerously misleading. Score another
>>"brilliant" idea for Microsoft, from a long line of such ... Bob ...
>>paperclip ... nonstandard HTML quotes ... \ for directory separator
>>char ... the list goes on and on!
>
> But he is still an MCP.

?

--
http://www.gnu.org/philosophy/right-to-read.html
Palladium? Trusted Computing? DRM? Microsoft? Sauron.
"One ring to rule them all, one ring to find them
One ring to bring them all, and in the darkness bind them."

Ian Moyce
07-09-2005, 11:34 PM
Twisted One wrote:
> Ian Moyce wrote:
>> Twisted One wrote:
>>> Ian Moyce wrote:
>>>> (MVP) wrote:
>>>>
>>>>> (bollocks)
>>>
>>> His suggestion to use agent ransack was not bollocks. Explorer's
>>> search is broken as designed and dangerously misleading. Score
>>> another "brilliant" idea for Microsoft, from a long line of such
>>> ... Bob ... paperclip ... nonstandard HTML quotes ... \ for
>>> directory separator char ... the list goes on and on!
>>
>> But he is still an MCP.
>
> ?

Never mind.

sbb78247
07-09-2005, 11:34 PM
Ian Moyce wrote:
> Twisted One wrote:
>> Ian Moyce wrote:
>>> Twisted One wrote:
>>>> Ian Moyce wrote:
>>>>> (MVP) wrote:
>>>>>
>>>>>> (bollocks)
>>>>
>>>> His suggestion to use agent ransack was not bollocks. Explorer's
>>>> search is broken as designed and dangerously misleading. Score
>>>> another "brilliant" idea for Microsoft, from a long line of such
>>>> ... Bob ... paperclip ... nonstandard HTML quotes ... \ for
>>>> directory separator char ... the list goes on and on!
>>>
>>> But he is still an MCP.
>>
>> ?
>
> Never mind.

Oh come on, slap him with a clue bat!

Ian Moyce
07-09-2005, 11:34 PM
sbb78247 wrote:
> Ian Moyce wrote:
>> Twisted One wrote:
>>> Ian Moyce wrote:
>>>> Twisted One wrote:
>>>>> Ian Moyce wrote:
>>>>>> (MVP) wrote:
>>>>>>
>>>>>>> (bollocks)
>>>>>
>>>>> His suggestion to use agent ransack was not bollocks. Explorer's
>>>>> search is broken as designed and dangerously misleading. Score
>>>>> another "brilliant" idea for Microsoft, from a long line of such
>>>>> ... Bob ... paperclip ... nonstandard HTML quotes ... \ for
>>>>> directory separator char ... the list goes on and on!
>>>>
>>>> But he is still an MCP.
>>>
>>> ?
>>
>> Never mind.
>
> Oh come on, slap him with a clue bat!

phallus cranium, putting it politely.

Rebecca
07-09-2005, 11:34 PM
Twisted One wrote:
> Rebecca wrote:
>> You're the only one that didn't get it.
>
> Why not help me to "get it" then?
>
> Besides, how can you possibly claim that? The newsgroup has a
> potential audience in the hundreds of millions. You have no way of
> knowing for sure how many of those people may or may not have read
> that post without "getting it".

I polled them.

Twisted One
07-09-2005, 11:34 PM
Rebecca wrote:
> Twisted One wrote:
>>Besides, how can you possibly claim that? The newsgroup has a
>>potential audience in the hundreds of millions. You have no way of
>>knowing for sure how many of those people may or may not have read
>>that post without "getting it".
>
> I polled them.

You should know that Internet polls are inherently unreliable and
unscientific. That is to say, they prove absolutely nothing. Nada. Zip.
Zero. Zilch. Responders are self-selecting -- there's bias source #1.
Anyone might lie. There's source #2. Unless a lot of hashing and strong
crypto is used, errors will creep in from network unreliability,
Microsoft software, and other sources. This won't produce a systematic
bias, but it will make any results approximate, this destroying any
usefulness for making absolute claims rather than "approximately half of
our respondents chose Pepto-Bismol over the other leading brand" or
whatever. So "Everybody except <name> believes X" and the like are right
out. Also, without good crypto, anyone can stuff the ballot box, alter
someone else's vote, or otherwise corrupt the process, which is bias
source #3. There are probably more bias sources I'm missing, too. :)

--
http://www.gnu.org/philosophy/right-to-read.html
Palladium? Trusted Computing? DRM? Microsoft? Sauron.
"One ring to rule them all, one ring to find them
One ring to bring them all, and in the darkness bind them."

Damian
07-09-2005, 11:35 PM
Twisted One wrote:
> Rebecca wrote:
>> Twisted One wrote:
>>> Besides, how can you possibly claim that? The newsgroup has a
>>> potential audience in the hundreds of millions. You have no way of
>>> knowing for sure how many of those people may or may not have read
>>> that post without "getting it".
>>
>> I polled them.
>
> You should know that Internet polls are inherently unreliable and
> unscientific. That is to say, they prove absolutely nothing. Nada.
> Zip. Zero. Zilch. Responders are self-selecting -- there's bias
> source #1. Anyone might lie. There's source #2. Unless a lot of
> hashing and strong crypto is used, errors will creep in from network
> unreliability, Microsoft software, and other sources. This won't
> produce a systematic bias, but it will make any results approximate,
> this destroying any usefulness for making absolute claims rather than
> "approximately half of our respondents chose Pepto-Bismol over the
> other leading brand" or whatever. So "Everybody except <name>
> believes X" and the like are right out. Also, without good crypto,
> anyone can stuff the ballot box, alter someone else's vote, or
> otherwise corrupt the process, which is bias source #3. There are
> probably more bias sources I'm missing, too. :)

As I told Rebecca when she polled me, you're the only one who didn't get it.

Diogenes
07-09-2005, 11:35 PM
Twisted One wrote:
> Rebecca wrote:
>> Twisted One wrote:
>>> Besides, how can you possibly claim that? The newsgroup has a
>>> potential audience in the hundreds of millions. You have no way of
>>> knowing for sure how many of those people may or may not have read
>>> that post without "getting it".
>>
>> I polled them.
>
> You should know that Internet polls are inherently unreliable and
> unscientific. That is to say, they prove absolutely nothing. Nada.
> Zip. Zero. Zilch. Responders are self-selecting -- there's bias
> source #1. Anyone might lie. There's source #2. Unless a lot of
> hashing and strong crypto is used, errors will creep in from network
> unreliability, Microsoft software, and other sources. This won't
> produce a systematic bias, but it will make any results approximate,
> this destroying any usefulness for making absolute claims rather than
> "approximately half of our respondents chose Pepto-Bismol over the
> other leading brand" or whatever. So "Everybody except <name>
> believes X" and the like are right out. Also, without good crypto,
> anyone can stuff the ballot box, alter someone else's vote, or
> otherwise corrupt the process, which is bias source #3. There are
> probably more bias sources I'm missing, too. :)

Rebecca asked me, and I agreed with her completely.

Twisted One
07-09-2005, 11:35 PM
Damian wrote:
> As I told Rebecca when she polled me, you're the only one who didn't get it.

You have no more authority to make such a sweeping claim than she does.

--
http://www.gnu.org/philosophy/right-to-read.html
Palladium? Trusted Computing? DRM? Microsoft? Sauron.
"One ring to rule them all, one ring to find them
One ring to bring them all, and in the darkness bind them."

relic
07-09-2005, 11:35 PM
Twisted One wrote:
> Rebecca wrote:
>> Twisted One wrote:
>>> Besides, how can you possibly claim that? The newsgroup has a
>>> potential audience in the hundreds of millions. You have no way of
>>> knowing for sure how many of those people may or may not have read
>>> that post without "getting it".
>>
>> I polled them.
>
> You should know that Internet polls are inherently unreliable and
> unscientific. That is to say, they prove absolutely nothing. Nada.
> Zip. Zero. Zilch. Responders are self-selecting -- there's bias
> source #1. Anyone might lie. There's source #2. Unless a lot of
> hashing and strong crypto is used, errors will creep in from network
> unreliability, Microsoft software, and other sources. This won't
> produce a systematic bias, but it will make any results approximate,
> this destroying any usefulness for making absolute claims rather than
> "approximately half of our respondents chose Pepto-Bismol over the
> other leading brand" or whatever. So "Everybody except <name>
> believes X" and the like are right out. Also, without good crypto,
> anyone can stuff the ballot box, alter someone else's vote, or
> otherwise corrupt the process, which is bias source #3. There are
> probably more bias sources I'm missing, too. :)

I found her poll to follow the accepted norms of Scientific polling. I
doubted her too, but was satisfied after I looked at her techniques and
data.

--
If there is a Tourist Season, how come we can't shoot them?

chrisv
07-09-2005, 11:35 PM
Twisted One wrote:
> Rebecca wrote:
>> Twisted One wrote:
>>> Besides, how can you possibly claim that? The newsgroup has a
>>> potential audience in the hundreds of millions. You have no way of
>>> knowing for sure how many of those people may or may not have read
>>> that post without "getting it".
>>
>> I polled them.
>
> You should know that Internet polls are inherently unreliable and
> unscientific. That is to say, they prove absolutely nothing. Nada.
> Zip. Zero. Zilch. Responders are self-selecting -- there's bias
> source #1. Anyone might lie. There's source #2. Unless a lot of
> hashing and strong crypto is used, errors will creep in from network
> unreliability, Microsoft software, and other sources. This won't
> produce a systematic bias, but it will make any results approximate,
> this destroying any usefulness for making absolute claims rather than
> "approximately half of our respondents chose Pepto-Bismol over the
> other leading brand" or whatever. So "Everybody except <name>
> believes X" and the like are right out. Also, without good crypto,
> anyone can stuff the ballot box, alter someone else's vote, or
> otherwise corrupt the process, which is bias source #3. There are
> probably more bias sources I'm missing, too. :)

This was not Rebecca's first poll, she knows exactly how to conduct a
scientific poll. Trust her results.

Twisted One
07-09-2005, 11:35 PM
relic wrote:
> I found her poll to follow the accepted norms of Scientific polling. I
> doubted her too, but was satisfied after I looked at her techniques and
> data.

OK. Then Rebecca won't mind if I ask her to post here the full
methodology, data, &c, including error estimates, regression analyses,
and a mathematically airtight proof that she reached and got answers
from every person who read that post anywhere on Earth, and indeed will
not merely "not mind" but comply with said request.

Well? How about it, Rebecca? I eagerly await the above-requested
information. Until there's been lots of independent peer review of all
of those requested items there's nothing scientific about this, after all.

--
http://www.gnu.org/philosophy/right-to-read.html
Palladium? Trusted Computing? DRM? Microsoft? Sauron.
"One ring to rule them all, one ring to find them
One ring to bring them all, and in the darkness bind them."

rapskat
07-09-2005, 11:35 PM
begin Error Log for Wed, 18 May 2005 17:43:21 -0700 - "chrisv"
<chrisv@nospam.invalid> caused an invalid page fault at address
<428be243$0$67568$c3e8da3@news.astraweb.com>, details as follows:

> This was not Rebecca's first poll, she knows exactly how to conduct a
> scientific poll. Trust her results.

Forgers are the worst sort of scumbag.

Usenet identities are free, so get your own you silly bitch.

--
rapskat - 22:05:13 up 1 day, 20:29, 3 users, load average: 0.24, 0.32, 0.26
"Industry wags are saying that God invented SCO to give people a
company to hate more than Microsoft."
-- http://www.linuxworld.com/story/38045.htm

Toad
07-10-2005, 12:05 AM
Twisted One wrote:

> relic wrote:
> > I found her poll to follow the accepted norms of Scientific
> > polling. I doubted her too, but was satisfied after I looked at her
> > techniques and data.
>
> OK. Then Rebecca won't mind if I ask her to post here the full
> methodology, data, &c, including error estimates, regression
> analyses, and a mathematically airtight proof that she reached and
> got answers from every person who read that post anywhere on Earth,
> and indeed will not merely "not mind" but comply with said request.
>
> Well? How about it, Rebecca? I eagerly await the above-requested
> information. Until there's been lots of independent peer review of
> all of those requested items there's nothing scientific about this,
> after all.

Bravo Foxtrot Delta


Windows Explorer search file contents not working on .sql files.