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

Reply via email to