Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

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

by perrin (Chancellor)
on Apr 23, 2004 at 22:19 UTC ( [id://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.

    gryphon
    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?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (6)
As of 2024-04-19 11:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found