WQL - Select /Where structure

[alfie002]

Dear all,

I have the following piece of code which is to select the Name from the Win_Directory where the corresponding Path has a specific value.

The line in question is

Set colItems=objWMIService.ExecQuery("Select Name from Win32_Directory where Path = 'c:\utilities'")

The query runs without error but doesn't return a value. The c:\utilities does exist on the c:\ drive.


Any ideas why this code isn't returning a value.

Thanks and regards

Alf

 

[cmartin75]

You must include double \ in the pathname.

C:\\utilities

 

[tsuji]

>Set colItems=objWMIService.ExecQuery("Select Name from Win32_Directory where Path = 'c:\utilities'")

[1] If c:\utilities is a directory and you want to return name of subdirectories, it is this.
[tt]
Set colItems=objWMIService.ExecQuery("Select Name from Win32_Directory where drive=""c:"" and path='\\utilities\\'")[/tt]

[2] If c:\utilities is a directory and you want to return the name of it(self) - not much to ask..., it is this.
[tt]
Set colItems=objWMIService.ExecQuery("Select Name from Win32_Directory where [red]name[/red]='c:[red]\[/red]\utilities'")[/tt]

For this matter, you have no other way than to read the documentation.

http://msdn.microsoft.com/en-us/library/aa394130(VS.85).aspx

 

[alfie002]

Thanks cmartin75 and tsuji.

Alf