[Slashcode-development] Oracle Port Progress, April 16: hello world

[Stephen C. <the...@wa...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I end my work on Slash today with milestone #2: the front page displays in all
its glory.  Doesn't get too far past that :)  But it's still nice to see the
meat of the system working.

The foolish inconsistency of the day involves fetchrow_hashref.  I was seeing
successful template fetches but the final output came out completely blank.  The
problem stems from fetchrow_hashref using (by default) $sth->{NAME} as the
column list to get the hash keys.  In Oracle, the keys returned by $sth->{NAME}
are always upper case, and as you have probably already guessed, all the key
requests in Slash::Display::Provider are lower case.

The fix is to change the calls to fetchrow_hashref in Slash::DB::Utility to:

... ->fetchrow_hashref('NAME_lc');

What I'm curious about is if this change breaks anything on the MySQL end, since
I've made it in Slash::DB::Utility (and I'm still too lazy to get MySQL set up
locally to actually test these things myself).  If anyone cares to patch
- --by-hand Slash::DB::Utility (there are three occurences of fetchrow_hashref in
there), I'd be curious to know the results.

Well, this was a welcome break, but sadly my real job summons me to perform late
night server upgrades.  More progress tomorrow (we hope :)

- -- 
Stephen Clouse <the...@wa...>
warpcore.org Founder, Chief Megalomaniac, and Evil Overlord

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBOtumZt1EXk7JbKbMEQJ/NACeOmJowLG4E7O9tWq+kInN7fbrjx0An1NS
z3jyNwQ+jeNI42xgd4kVM76Q
=7ayH
-----END PGP SIGNATURE-----