converthtml

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by joy » converthtml

converthtml

Rate Topic

Display Mode

Topic Options

Author

Message

joy-550396

Posted Tuesday, January 13, 2009 3:56 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 5:29 AM
Points: 3, Visits: 72

Comments posted to this topic are about the item converthtml

Post #635897

Tim Wilson-Brown

Posted Wednesday, January 21, 2009 3:12 PM

SSC Veteran

Group: General Forum Members
Last Login: Sunday, August 19, 2012 6:40 PM
Points: 202, Visits: 301

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 &amp;amp; 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?

Post #641196

Tim Wilson-Brown

Posted Wednesday, January 21, 2009 9:26 PM

SSC Veteran

Group: General Forum Members
Last Login: Sunday, August 19, 2012 6:40 PM
Points: 202, Visits: 301

Also, if the rows are returned in the order they're inserted,
your code will double-convert sequences like:

&gt;

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 Smile

Post #641355

joy-550396

Posted Thursday, January 22, 2009 2:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 5:29 AM
Points: 3, Visits: 72

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

Post #641450

« Prev Topic | Next Topic »

Permissions