Reputation: 11200
i have a simple powershell script, like this
sqlcmd -S. -E -Q 'select ''$(x)''' -v x="c:a"
but i always got the error message
Sqlcmd: ':a': Invalid argument. Enter '-?' for help.
i figured out that it is the ":"
in the argument caused the problem, but i do not know how to escape it.
thanks, David
Upvotes: 1
Views: 1970
Reputation: 104
You could also alternatively try this approach that we used for scripting xdt:Transforms.
$xmlSection.SetAttribute("xdtTransform","Insert")
followed by
foreach-object {$_ -replace "xdtTransform" , "xdt:Transform"}
Upvotes: 0
Reputation: 11200
sorry that i have to answer to my own question again.
the only way to solve this problem is to use '+' to concatenate the two string, and the ':' will be reserved.
e.g. $a="abc"+":123"
Upvotes: 3
Reputation: 3874
The backquote character is the escape code in PowerShell. So write ``:` ....
oops... That won't work for the colon character. Use %3A
instead.
Upvotes: -1