Comprehensive HTML Database Documentation Problem

Question

Post reply

Comprehensive HTML Database Documentation Problem

Mike Glenn

Valued Member

Points: 55
More actions
May 2, 2006 at 7:48 pm

#168024

Okay, I'm obviously missing something basic here, but the "Comprehensive HTML Database Documentation" script submitted by Terry Grignon generates HTML that does not render correctly in a browser. After saving it in a file with the HTM or HTML extension and opening in a browser, I just see the raw HTML. Since I haven't found other posts asking about this, apparently everyone except me knows you obviously do "X" to make the HTML render properly. Would someone be so kind as to fill me in on what "X" is?

Viewing 9 posts - 1 through 8 (of 8 total)

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

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 1

i just tested it as i've not seen these scripts before and have no problems at all - no x required.

are you using the revised version posted most recently?

other than that - take the file to another machine to test to see if it's your browser

MVDBA

Mike Glenn Valued Member Points: 55 More actions · Answer 2

Thanks for the reponse. You gave me the confidence to try again. Sure enough, the output renders correctly now on the same machine. The only difference I can think of is last night I was working from home over a VPN connection and now I'm in the office at the physical machine...

Lowell SSC Guru Points: 323518 More actions · Answer 3

I found that to be a great script as well; the only change I made was adding a   to the closing </TD> tag so that cells didn't appear wierd if no data was entered in them by the script.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Mike Glenn Valued Member Points: 55 More actions · Answer 4

Mike Glenn

Valued Member

Points: 55

May 4, 2006 at 7:30 am

#635917

Thanks for the tip.

Mike Glenn Valued Member Points: 55 More actions · Answer 5

Lowell, do you mean, add   to every </TD> tag in the script like this: <  /TD> ?

My knowledge of HTML is rather thin...

Lowell SSC Guru Points: 323518 More actions · Answer 6

almost, i replaced every </TD> with  </TD> as there are a few places where the cells have no contents; they render as <TD></TD>, so they don't look right in the finishe3d report; adding the non-greaking space makes the cell appear empty, which for me was just a display issue, but it still looks better.

either prerendering or postrendering, try it and compare the reports;

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Mike Glenn Valued Member Points: 55 More actions · Answer 7

Ah, I see the difference! Very nice. Thanks again.

Mike Glenn Valued Member Points: 55 More actions · Answer 8

And here's an extremely simple, but useful modification to the report heading (I put it right undeneath the centered "Database Definition" heading):

SELECT @strHTML = '<CENTER>documented ' + cast(getdate() as varchar(64)) + '</CENTER> '

PRINT @strHTML

Cheers