Extra Columns in HTML Output From SQLcmd

This topic contains 3 replies, has 3 voices, and was last updated by Profile photo of Warren Frame Warren Frame 1 year, 7 months ago.

  • Author
    Posts
  • #29022
    Profile photo of Yul
    Yul
    Participant

    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,

  • #29024
    Profile photo of Don Jones
    Don Jones
    Keymaster

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

  • #29026
    Profile photo of Yul
    Yul
    Participant

    Ahh, so simple...

    Thank you very much!

  • #29030
    Profile photo of Warren Frame
    Warren Frame
    Participant

    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!

You must be logged in to reply to this topic.