Escape it by using backtick (`) as an escape character for the dollar sign ($).

Also, try to enclose the statement in single-quotes instead of the double-quotes you are using now.


How can we round off a number to the nearest 10 in php?

Say I have `23`, what code would I use to round it off to `30`?

How to round up a number to nearest 10?

What is an easy way to make text blinking in jQuery and a way to stop it? Must work for IE, FF and Chrome. Thanks

Text blinking jQuery

I am trying to open an SQL data connection using a PowerShell script and my password contains a `$` sign:

    $cn = new-object system.data.SqlClient.SqlConnection(&quot;Data Source=DBNAME;Initial Catalog=Catagory;User ID=User;Password=pass$word;&quot;)

When I try to open a connection it says:

&gt; Login failed



PowerShell script not accepting $ (dollar) sign

I am trying to open an SQL data connection using a PowerShell script and my password contains a <code>$</code> sign:
<pre><code class="hljs language-php">$cn = new-object system.data.SqlClient.SqlConnection("Data Source=DBNAME;Initial Catalog=Catagory;User ID=User;Password=pass$word;")
</code></pre>
When I try to open a connection it says:
> Login failed

I run the following code using PowerShell to get a list of add/remove programs from the registry:

    Get-ChildItem -path hklm:\software\microsoft\windows\currentversion\uninstall `
        | ForEach-Object -Process { Write-Output $_.GetValue(&quot;DisplayName&quot;) } `
        | Out-File addrem.txt

I want the list to be separated by newlines per each program. I&#39;ve tried:

    Get-ChildItem -path hklm:\software\microsoft\windows\currentversion\uninstall `
        | ForEach-Object -Process { Write-Output $_.GetValue(&quot;DisplayName&quot;) `n } `
        | out-file test.txt

    Get-ChildItem -path hklm:\software\microsoft\windows\currentversion\uninstall `
        | ForEach-Object {$_.GetValue(&quot;DisplayName&quot;) } `
        | Write-Host -Separator `n

    Get-ChildItem -path hklm:\software\microsoft\windows\currentversion\uninstall `
        | ForEach-Object -Process { $_.GetValue(&quot;DisplayName&quot;) } `
        | foreach($_) { echo $_ `n }

But all result in weird formatting when output to the console, and with three square characters after each line when output to a file. I tried `Format-List`, `Format-Table`, and `Format-Wide` with no luck. Originally, I thought something like this would work:

    Get-ChildItem -path hklm:\software\microsoft\windows\currentversion\uninstall `
        | ForEach-Object -Process { &quot;$_.GetValue(&quot;DisplayName&quot;) `n&quot; }

But that just gave me an error.


How do I add a newline to command output in PowerShell?

I have multiple volumes (as nearly everybody nowadays): on Windows they end up specified as C:, D: and so on. How do I list these all like on a Unix machine with &quot;ls /mnt/&quot; with Powershell? 

List all devices, partitions and volumes in Powershell

How do you run the following command in PowerShell?

&gt; C:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe -verb:sync -source:dbfullsql=&quot;Data Source=mysource;Integrated Security=false;User ID=sa;Pwd=sapass!;Database=mydb;&quot; -dest:dbfullsql=&quot;Data Source=.\mydestsource;Integrated Security=false;User ID=sa;Pwd=sapass!;Database=mydb;&quot;,computername=10.10.10.10,username=administrator,password=adminpass&quot;


How to run an EXE file in PowerShell with parameters with spaces and quotes

Is there a way to clear the $Error variable that tracks errors in a PowerShell session?

If so, how do you do it?

I have tried:
`$error.clear`

In the PowerShell ISE on Windows 7 and the $Error array is still populated.


How to clear $Error in PowerShell?

I have a PowerShell 1.0 script to just open a bunch of applications. The first is a virtual machine and the others are development applications.  I want the virtual machine to finish booting before the rest of the applications are opened.

In bash I could just say `&quot;cmd1 &amp;&amp; cmd2&quot;`

This is what I&#39;ve got...

    C:\Applications\VirtualBox\vboxmanage startvm superdooper
        &amp;&quot;C:\Applications\NetBeans 6.5\bin\netbeans.exe&quot;



How to tell PowerShell to wait for each command to end before starting the next?

I&#39;m trying to convert the `String`  `\something\` into the `String` `\\something\\` using `replaceAll`, but I keep getting all kinds of errors. I thought this was the solution:

    theString.replaceAll(&quot;\\&quot;, &quot;\\\\&quot;);

But this gives the below exception: 

    java.util.regex.PatternSyntaxException: Unexpected internal error near index 1


String.replaceAll single backslashes with double backslashes

I&#39;m trying to add an actual percent sign into a printf statement in Java and I&#39;m getting the error:

    lab1.java:166: illegal escape character
                    System.out.printf(&quot;%s\t%s\t%1.2f\%\t%1.2f\%\n&quot;,ID,pattern,support,confidence);
                                                     ^
    lab1.java:166: illegal escape character
                    System.out.printf(&quot;%s\t%s\t%1.2f\%\t%1.2f\%\n&quot;,ID,pattern,support,confidence);
                                                              ^
    2 errors

I can&#39;t figure out how to put an actual percent sign into my printf? I thought using \% to escape it would work, but it isn&#39;t.

Any ideas?

Java: Literal percent sign in printf statement

In [nodejs][1], the only way to execute external commands is via sys.exec(cmd). I&#39;d like to call an external command and give it data via stdin. In nodejs there does yet not appear to be a way to open a command and then push data to it (only to exec and receive its standard+error outputs), so it appears the only way I&#39;ve got to do this right now is via a single string command such as:

    var dangerStr = &quot;bad stuff here&quot;;
    sys.exec(&quot;echo &#39;&quot; + dangerStr + &quot;&#39; | somecommand&quot;);

Most answers to questions like this have focused on either regex which doesn&#39;t work for me in nodejs (which uses Google&#39;s V8 Javascript engine) or native features from other languages like Python.

I&#39;d like to escape dangerStr so that it&#39;s safe to compose an exec string like the one above. If it helps, dangerStr will contain JSON data.

  [1]: http://nodejs.org/

How do I escape a string for a shell command in node?

Apparently, this is harder to find than I thought it would be. And it even is so simple...

Is there a function equivalent to PHP&#39;s [htmlspecialchars][1] built into JavaScript? I know it&#39;s fairly easy to implement that yourself, but using a built-in function, if available, is just nicer.

For those unfamiliar with PHP, htmlspecialchars translates stuff like &lt;code&gt;&amp;lt;htmltag/&amp;gt;&lt;/code&gt; into &lt;code&gt;&amp;amp;lt;htmltag/&amp;amp;gt;&lt;/code&gt;

I know that &lt;code&gt;escape()&lt;/code&gt; and &lt;code&gt;encodeURI()&lt;/code&gt; do not work this way.

  [1]: https://www.php.net/manual/en/function.htmlspecialchars.php



What is the HtmlSpecialChars equivalent in JavaScript?

I&#39;m trying to put some anti sql injection in place in java and am finding it very difficult to work with the the &quot;replaceAll&quot; string function. Ultimately I need a function that will convert any existing `\` to `\\`, any `&quot;` to `\&quot;`, any `&#39;` to `\&#39;`, and any `\n` to `\\n` so that when the string is evaluated by MySQL SQL injections will be blocked. 

I&#39;ve jacked up some code I was working with and all the `\\\\\\\\\\\` in the function are making my eyes go nuts. If anyone happens to have an example of this I would greatly appreciate it.

Content Type	Original Author	Original Content on Stackoverflow
Question	Murtaza Mandvi	View Question on Stackoverflow
Solution 1 - Powershell	Shankar R10N	View Answer on Stackoverflow

PowerShell script not accepting $ (dollar) sign

Powershell Problem Overview

Powershell Solutions

Solution 1 - Powershell

Text blinking jQuery

How to round up a number to nearest 10?

Attributions