use trace.
Tim.
On Thu, Jul 19, 2001 at 01:31:50PM -0400, Brennan, Corey wrote:
> 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
