Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Re: using CGI, DBI and HTML::Template (a mini tutorial with example code)

by gav^ (Curate)
on Feb 12, 2002 at 16:47 UTC ( [id://144904]=note: print w/replies, xml ) Need Help??


in reply to Re: using CGI, DBI and HTML::Template (a mini tutorial with example code)
in thread using CGI, DBI and HTML::Template (a mini tutorial with example code)

Thanks for the tip, I just upgraded from 1.15 to 1.201 and found this broken. Now I'm worried as I have to make sure nobody upgrades DBI and causes all my scripts to break.

gav^

  • Comment on Re: Re: using CGI, DBI and HTML::Template (a mini tutorial with example code)

Replies are listed 'Best First'.
Re: Re: Re: using CGI, DBI and HTML::Template (a mini tutorial with example code)
by blue_dragon99uk (Initiate) on Oct 15, 2002 at 03:12 UTC
    Good Tutorial, though l have to admit l did get caught out my the selectall_hashref and after searching this site, l found an easy solution to it: 
    my $table_data = $dbh->prepare($companyquery);
$table_data->execute;

my $arrayref = $table_data->fetchall_arrayref({});
$template->param(ROWS => $arrayref);

    [download]
    Hope this helps
[reply]
[d/l]
      This one works much better. Thanks alot for sharing it with me. I really need it
[reply]

In Section Meditations

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://144904]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2024-04-20 15:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found