I am new to perl, and I have been taking pieces and parts from other scripts I have found in an effort to try and get comfortable with perl. I am trying to query a database and display the information that I get on a webpage using HTML::Template.
Here is what I am using to get the data:
my $sth = $dbh->prepare( "SELECT alpha FROM main WHERE alpha LIKE '%$s
+earch_ip %'" );
my ($complete_match) = $sth->fetchrow_array;
That gets my information out of the database, but how do I get that into HTML::Template? I have tried this:
$template->param(cm => $complete_match);
print $CGI->header( );
print $CGI->title("returned data!");
That gives me the follwoing error:
HTML::Template::param() : attempt to set parameter 'cm' with a scalar - parameter is not a TMPL_VAR! at /var/www/asd/www.pl line 60
If someone could point me in the right direction, it would be much appreciated.
Thank you very much.