Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Re: Re: Dynamic DSN w/ Class::DBI Example

by perrin (Chancellor)
on Apr 23, 2004 at 22:19 UTC ( #347769=note: print w/replies, xml ) Need Help??

in reply to Re: Re: Dynamic DSN w/ Class::DBI Example
in thread Dynamic DSN w/ Class::DBI Example

Get rid of that BaseDSN stuff. You have to subclass Class::DBI::MySQL, like you were before, to get the set_up_table method.
  • Comment on Re: Re: Re: Dynamic DSN w/ Class::DBI Example

Replies are listed 'Best First'.
Re: Re: Re: Re: Dynamic DSN w/ Class::DBI Example
by gryphon (Abbot) on Apr 23, 2004 at 22:22 UTC

    Switching to use base 'Class::DBI::mysql' results in an error of "Can't locate object method 'db_Main' via package 'Stuff::Item' at blah, blah". I think I'm not smart enough to use Class::DBI. Do you have any working example code you can share with me? Thanks.

    code('Perl') || die;

      Calm down, Class::DBI is much easier than lots of other things you've already learned.

      I'm guessing you are getting into trouble because you are calling set_up_table() before you call set_db(). That won't work because set_up_table() needs to talk to the database to find out about the table. So, load your other modules after you call set_db(). You could use require(), or you could put the call to set_db() in a BEGIN {} before you use() the other modules. And don't put them all in one file like that. It's cool, but not a good idea in the long run.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://347769]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (8)
As of 2021-10-20 11:32 GMT
Find Nodes?
    Voting Booth?
    My first memorable Perl project was:

    Results (81 votes). Check out past polls.