> -----Original Message-----
> From: Doc [mailto:[EMAIL PROTECTED]]
> Sent: 26 September 2002 05:12
> To: Norikatsu Shigemura
> Cc: [EMAIL PROTECTED]
> Subject: Re: [htmltmpl] HTML-Template and DBI
>
>
> I just realized something, doesnt fetch_array return column
> values and not column names? And data has to be in this format
>
> $template->param(EMPLOYEE_INFO => [
> { name => 'Sam', job => 'programmer' },
> { name => 'Steve', job => 'soda jerk' },
> ]);
>
> I tried printing every dbi fetch results and they dont turn
> out that. just {HASH} and bunch of numbers.
>
You can't print a hashref - get hold of the Data::Dumper module from CPAN if you
haven't already, and do:
use Data::Dumper;
print Dumper($name_of_my_hashref);
Data::Dumper will pretty-print data structures for you - very useful for debugging.
With regard to $sth->fetchall_arrayref(), by default it returns an array reference
containing an array ref for each row. HOWEVER, if you pass it an empty hash reference
like so: $sth->fetchall_arrayref( {} ), it will return a reference to an array
containing a hashref for each row... which is exactly what you need for an
HTML::Template loop (as described in the example you quoted above). See the DBI
manpages http://www.perldoc.com/cpan/DBI.html
regards,
Ben
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Html-template-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/html-template-users
