http://www.perlmonks.org?node_id=626486


in reply to DBI bind output vars by column name

Nice...
I would also suggest looking at Re^2: fetchrow_array as well.

-InjunJoel
"I do not feel obliged to believe that the same God who endowed us with sense, reason and intellect has intended us to forego their use." -Galileo
  • Comment on Re: DBI bind output vars by column name

Replies are listed 'Best First'.
Re^2: DBI bind output vars by column name
by Hercynium (Hermit) on Jul 14, 2007 at 00:07 UTC
    Thanks for the tip. Since posting that snippet and poking around gmax's stuff I've learned a few things that I know I could have used in the past (and probably will in the future)

    However, the code I wrote was to solve a different sort of problem. Because of the mapping, I can pass $bound_fields directly to the node_create() method of an object to create a fully-populated object without calling a whole bunch of setters.

    Also, since the script this code is in is used on several systems, querying several databases, the $RESULT_MAP is actually built from a config file to accommodate creating the same type of objects from tables with several different schemas.
[reply]

In Section Cool Uses for Perl