[KLUG Members] OpenOffice and mysql

[Mike Williams]

As usual, I managed to find a partial answer shortly after asking the 
question.  Mysql has a graphical query browser that displays stuff 
correctly, so I can use that if there's any doubt as to what's in the 
tables.

Of course when the real problem is writing queries correctly....

Mike Williams wrote:
> Does anybody have any experience using OpenOffice as a front end for a 
> mysql database?  I got them to talk to each other (with 64-bit 
> OpenOffice, no less!) through UnixODBC, but I'm having trouble with 
> the boolean / bit datatype in mysql.  The problem comes with a NULL 
> value in one of the boolean fields.  The OpenOffice interface only 
> shows "true" or "not true".  "Not true" includes both "false" and 
> "null", and there's no way to tell the difference through that 
> interface.  Talking to mysql through the mysql command-line client is 
> just as bad, though.  It only shows "null" or "not null", with both 
> "True" and "False" showing up as not null (displays as empty space).  
> So I can get everything to a True or False value, but I have to use 
> both interfaces and do things manually.  Can anybody suggest another 
> interface to mysql that handles bits a little better? Would that be a 
> "bit" better?  Couldn't resist...
>
> If it matters, I'm using mysql 5.0.42 and Openoffice 2.2.1
> Thanks.
>
> _______________________________________________
> Members mailing list
> Members at kalamazoolinux.org
>