Extra Columns in HTML Output From SQLcmd

PowerShell Help
1

Hi,

I’m getting extra columns when trying to output an SQL query to HTML. I get RowError, RowState, Table, ItemArray & HasErrors along with with my actual query results. These looks like property values attached to the object created by Invoke-Sqlcmd.

PS C:\> $myTable | ConvertTo-Html -as TABLE | Out-File C:\Test.htm PS C:\> Invoke-Expression C:\Test.htm

Any ideas how I can strip those out?

Thanks,

2

By default, ConvertTo-HTML converts ALL properties you give it into columns. Just use its -Prop parameter to specify the properties you want.

3

Ahh, so simple…

Thank you very much!

4

Hi!

In case you use it elsewhere, just an FYI: Invoke-Expression is a bit risky, and can expose you to code injection.

Invoke-Item would work in this example.

Cheers!