Ways to deal with a "-" character

[=?Utf-8?B?TWlsaXRhcnkgU211cmY=?=]

I am trying to use a String as part of a query. Here is the line:

strQuery = "Select Filename, Path from d11mw-zes215643.System..SCOPE() where
Filename = 'main.swf'"

The code works IF I rename the target workstation and remove the - character
and then adjust my code accordingly. However, that isn't a real solution for
me, so what are ways to deal with the - character so that the code can handle
it?

Here is a reference I found pertaining to C# in the middle of this page, but
I can't do the exact same thing in VB.NET...

http://www.sellsbrothers.com/news/sh...x?ixTopic=1949

Thanks

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Military Smurf,

If the article is correct that you need to surround the name with
double-quote characters then you can do that in VB by using 2 double-quote
characters, like this:

strQuery = "Select Filename, Path from ""d11mw-zes215643"".System..SCOPE()
where Filename = 'main.swf'"

Kerry Moorman
"Military Smurf" wrote:

I am trying to use a String as part of a query. Here is the line:

strQuery = "Select Filename, Path from d11mw-zes215643.System..SCOPE() where
Filename = 'main.swf'"

The code works IF I rename the target workstation and remove the - character
and then adjust my code accordingly. However, that isn't a real solution for
me, so what are ways to deal with the - character so that the code can handle
it?

Here is a reference I found pertaining to C# in the middle of this page, but
I can't do the exact same thing in VB.NET...

http://www.sellsbrothers.com/news/sh...x?ixTopic=1949

Thanks

[zacks]

On Mar 23, 1:28 pm, Military Smurf
<[e-mail]:

I am trying to use a String as part of a query. Here is the line:

strQuery = "Select Filename, Path from d11mw-zes215643.System..SCOPE() where
Filename = 'main.swf'"

The code works IF I rename the target workstation and remove the - character
and then adjust my code accordingly. However, that isn't a real solution for
me, so what are ways to deal with the - character so that the code can handle
it?

Here is a reference I found pertaining to C# in the middle of this page, but
I can't do the exact same thing in VB.NET...

http://www.sellsbrothers.com/news/sh...x?ixTopic=1949

Thanks

Not sure if it works for you in this case, but I do know that if a SQL
object like a table name or a column name has embedded spaces in it
you must enclose the object's name inside square brackets in the SQL
statement as in:

strQuery = "Select Filename, Path from [d11mw-
zes215643].System..SCOPE() where
Filename = 'main.swf'"

[=?Utf-8?B?TWlsaXRhcnkgU211cmY=?=]

Ah, that's the ticket.

DOMO ARIGATO GOZAIMASU!!!

"Kerry Moorman" wrote:

Military Smurf,

If the article is correct that you need to surround the name with
double-quote characters then you can do that in VB by using 2 double-quote
characters, like this:

strQuery = "Select Filename, Path from ""d11mw-zes215643"".System..SCOPE()
where Filename = 'main.swf'"

Kerry Moorman
"Military Smurf" wrote:

I am trying to use a String as part of a query. Here is the line:

strQuery = "Select Filename, Path from d11mw-zes215643.System..SCOPE() where
Filename = 'main.swf'"

The code works IF I rename the target workstation and remove the - character
and then adjust my code accordingly. However, that isn't a real solution for
me, so what are ways to deal with the - character so that the code can handle
it?

Here is a reference I found pertaining to C# in the middle of this page, but
I can't do the exact same thing in VB.NET...

http://www.sellsbrothers.com/news/sh...x?ixTopic=1949

Thanks