Esteemed monks,

My poor little brain is having trouble wrapping itself around things to do with OO Perl specifically where it concerns Class::DBI.

My task:

• To get a hash from a Class::DBI method seems impossible.
  
  Currently I use:

  my %data;
  my $obj = App::User->search( username => 'fred' );
  while ( my $usr = $obj->next ) {
      foreach ( $user->columns ) {
          $data{$_} = $usr->$_;
      }
  }
  [download]

  But this seems rather left handed and backwards if I am to do this every time I want a hash! If I need to do this then why am I using Class::DBI at all, it is actually costing me code in many cases. Surely there must be a better way?

Anybody help please?

jdtoronto

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.