Hi all,
I am having trouble getting a script ported over to NT from Unix. This
syntax works on the Unix side but when I try it on NT I get the following
error:
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver] Too
few parameters. Expected 3. (SQL-07001)(DBD:st_execute/SQL
Execute err=-1) at C:\Program Files\ipc\pricing_tool\maxgen\ESR_PwrReport.pl
line 257.
select description from t_system_symbols where name_space = "COUNTRY" and
value = ? Error
The code looks like this:
$statement =("select description from t_system_symbols where
name_space = \"COUNTRY\" and value = ?");
$row = &get_sql_data($statement, $country_temp);
$country = $row->[0];
sub get_sql_data {
my ($stmt, @parm) = @_;
my $sth = $dbh->prepare_cached($stmt) or die ("$stmt\n");
$sth->execute(@parm) or die ("$stmt Error\n");
my $row = $sth->fetchrow_arrayref();
undef $sth;
return $row;
}
Any help would be greatly appreciated.
Thanks in advance
---
Corey Brennan