converthtml

  • joy-550396

    SSC Rookie

    Points: 31

    Comments posted to this topic are about the item converthtml

  • Tim Wilson-Brown

    Ten Centuries

    Points: 1395

    When you posted your article to the site, all your HTML escape codes were converted to their actual equivalents - so I see:

    insert @htmltable values('&', '&')

    instead of:

    insert @htmltable values('&', '&')

    (to generate the & above, I actually needed to type & in my reply)

    Could you please repost this article with your SQL code attached as a file?

    Also, given that it's an issue with the site, do you know who to talk to to get it fixed?

  • Tim Wilson-Brown

    Ten Centuries

    Points: 1395

    Also, if the rows are returned in the order they're inserted,

    your code will double-convert sequences like:

    >

    which should expand to:

    >

    but your code will convert to:

    >

    The & to & conversion must happen last - or you run the risk of double-conversion.

    Since you can't guarantee the order the rows will be returned, this could be a tricky one 🙂

  • joy-550396

    SSC Rookie

    Points: 31

    Dear Reader

    Thanks for your feedback, I have sent the converthtml script as a file attachment to webmaster@sqlservercentral.com

    I hope the webmaster will publish it soon.

    Kind regards

    Joy

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply