Could you be more specific? Are you seeing any error messages? Are you running the 
script from the command line or via CGI?

If the output of your script is destined for a browser, you need to print the 
appropriate headers... If the script is running in a standard CGI environment, 
something like:

use CGI qw(:standard);
print header, $template->output;


Please also post the template you are using.

regards,
Ben


> -----Original Message-----
> From: Doc [mailto:[EMAIL PROTECTED]]
> Sent: 22 September 2002 15:44
> To: Ben Ausden; [EMAIL PROTECTED]
> Subject: Re: [htmltmpl] HTML-Template and DBI
> 
> 
> 
> my $DBH = DBI->connect($db_config{"dsn"}, $db_config{"username"},
> $db_config{"password"}, { PrintError => 0, AutoCommit => 1 }) 
> or die "Could
> not connect: $DBI::errstr";
> my $sth = $DBH->prepare('
>   <sql statement>
> ');
> $sth->execute();
> 
> my $template = HTML::Template->new(filename => 'template.html');
> my @rows = ();
> while ( my $data = $sth->fetchrow_hashref() ) {
>   push @rows, $data;
> }
> $template->param(ROWS => \@rows);
> 
> 
> 
> $DBH->disconnect();
> 
> Still doesnt work.
> 

[...]


-------------------------------------------------------
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

Reply via email to