Re: converting output of query into html (with tables)and ps (withtables)

[Michael Widenius]

>>>>> "Paul" == Paul DuBois <paul@stripped> writes:

Paul> At 11:28 AM -0400 9/13/99, Bob Kline wrote:
>> On Mon, 13 Sep 1999, Paul DuBois wrote:
>> 
>>> At 10:43 AM -0400 9/13/99, Bob Kline wrote:
>>> >On Mon, 13 Sep 1999, Bob Kline wrote:
>>> >
>>> >>  On Mon, 13 Sep 1999, Paul DuBois wrote:
>>> >>
>>> >>  >
>>> >>  > If you want something quick and dirty, try mysql --html.
>>> >>  > Even if you want to write your own program, you might find the
> output
>>> >>  > instructive.
>>> >>  >
>>> >>
>>> >>  Aah, I wasn't aware of this.  Thanks for the tip.  I notice,
> however,
>>> >>  that it's only available on my Linux server on which full mysql is
>>> >>  installed, but not in the client-only version I have on my NT
> server.
>>> >>
>>> >
>>> >I also notice that the output crams all the values into the first
>>> >column.  :-<}
>>> 
>>> 
>>> I must be lucky.  I don't observe this or the other problem just reported
>>> on the list.
>>> 
>> 
>> Perhaps it isn't luck.  Are you using a production (3.22.x) or a
>> development (3.23.x) version of mysql?

Paul> I thought I tried it with both, but I went back and checked more carefully.
Paul> The output seems wrong for 3.22.xx and correct for 3.23.xx.  A comparison
Paul> of the sources for mysql.cc from the two versions reveals that a print
Paul> statement to write "</TR>" was moved from inside a loop to after the loop.
Paul> That seems to account for the difference.

Hi!

I checked the 3.22.26 version of mysql.cc and this has the same code
that handles the html stuff as the 3.23.3 version.

It may be time for an upgrade...

Regards,
Monty