in reply to Anyone using DBIx::DBSchema + MySQL?

This worked for my test case. Have you tried something like: 
mysql -e'desc patient' -D ahp

[download]
to see a listing of the fields for that table? Perhaps that table is a MySQL table type that is not compatible with DBIx::DBSchema - i doubt it ...

As an alternative, have you tried DBI::Wrap or the more complex DBI::Class?

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Replies are listed 'Best First'.
Re:x2 Anyone using DBIx::DBSchema + MySQL?
by bsb (Priest) on Jun 21, 2003 at 07:57 UTC
    The table is there, has data and can be used with straight DBI, Class::DBI and even by Class::DBI::mysql which gets the schema automatically.

    DBIx::DBSchema seems to misparse or lose track of something since column types show up as column names. I haven't investigated very deeply yet. I probably never will, the module smells a bit funny.

    Thanks for checking anyway.

    Brad

[reply]

In Section Seekers of Perl Wisdom