> Perhaps folks are thinking of fetchrow_hashref which DOES return column
> names.
I agree. I think people are confusing array with a hash in DBI.
> See DBI doc on how to use DBI
> http://search.cpan.org/author/TIMB/DBI-1.14/DBI.pm
>
>
> Steve Ragan
> Sr. Internet Developer
> Harris Internet Services
> 2500 Westchester Ave.
> Purchase, NY 10577
> 914-641-3948
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Doc [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 26, 2002 2:18 PM
> To: Andrew Brosnan; [EMAIL PROTECTED]
> Subject: Re: [htmltmpl] HTML-Template and DBI
>
>
> That didn't make any sense whatsoever.
>
> DBI does not return column names in results.
>
> H-T needs column names to assign values to <TMPL_VAR NAME=VARNAME>
>
> So How is it possible to use $template->param(ROWS =>
> $sth->fechall_arrayref({}));
> when arrayref does not supply H-T what needs to perform it's function?
>
> ----- Original Message -----
> From: "Andrew Brosnan" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, September 26, 2002 1:20 PM
> Subject: Re: [htmltmpl] HTML-Template and DBI
>
>
> > On 9/26/02 at 12:54 PM, [EMAIL PROTECTED] (Doc) wrote:
> >
> > > What about tha fact dbi array doesn't contain column names?
> >
> > huh? If you (SELECT foo, bar, FROM db) returned will be a ref to the
> > values of foo & bar for each row that your querry matched.
> >
> >
> >
> > Have you looked at the 'bind columns' method? (untested):
> >
> > my $sth = $dbh->prepare( qq{ SELECT foo, bar FROM db WHERE [blah...] })
> > or die [blah...] ;
> >
> > $sth->execute()
> > or die [blah...] ;
> >
> > $sth->bind_columns(undef, \my($foo, $bar,))
> > or die [blah...];
> >
> > $sth->fetch;
> >
> > #Now feel free to use $foo and $bar
> >
> > $template->param(foo => $foo,
> > bar => $bar);
> >
> >
> >
> >
> > #For loops something like:
> >
> > my @loop;
> >
> > while(my $data = $sth->fetch) {
> >
> > my %row = ( foo => $foo,
> > bar => $bar, );
> > push (@loop, \%row);
> >
> > }
> >
> > $template->param(stuff => \@loop,);
> >
> >
> >
> >
> >
> > > ----- Original Message -----
> > > From: "Ben Ausden" <[EMAIL PROTECTED]>
> > > To: "Doc" <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > Sent: Thursday, September 26, 2002 4:52 AM
> > > Subject: RE: [htmltmpl] HTML-Template and DBI
> > >
> > >
> > >
> > > > -----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
>
>
>
> -------------------------------------------------------
> 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
-------------------------------------------------------
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
