Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

converthtml Expand / Collapse
Author
Message
Posted Tuesday, January 13, 2009 3:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 9, 2014 3:48 AM
Points: 3, Visits: 76
Comments posted to this topic are about the item converthtml
Post #635897
Posted Wednesday, January 21, 2009 3:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 5:40 PM
Points: 209, Visits: 302
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?
Post #641196
Posted Wednesday, January 21, 2009 9:26 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 5:40 PM
Points: 209, Visits: 302
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
Post #641355
Posted Thursday, January 22, 2009 2:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 9, 2014 3:48 AM
Points: 3, Visits: 76
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 »

Add to briefcase

Permissions Expand / Collapse