Post reply

converthtml

  • January 13, 2009 at 3:56 pm

    #196124

    Comments posted to this topic are about the item converthtml

  • January 21, 2009 at 3:12 pm

    #930745

    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?

  • January 21, 2009 at 9:26 pm

    #930873

    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 🙂

  • January 22, 2009 at 2:49 am

    #930949

    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 3 (of 3 total)

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