Friday, February 18, 2011

OpenOffice Base MySQL ALTER table structure

I may have missed it, but it's likely that you will have trouble refreshing table structure in OpenOffice Base if you connect to MySQL and ALTER a table.

Basically, the answer is to add the fields in the Edit of the table(s) in Base to match the new columns. If you don't know what they are, create a new table connecting to the ODBC of MySQL and edit the appropriate table.

It's a real pain, but there you are.

Tuesday, February 15, 2011

YUI3 accordion

I had the hardest time trying to override the label color in YUI3-accordion.
It turns out that !important was used in the default style, so I had to !important again to overwrite it. (I didn't want/need black on a dark background).

Blog Archive