RE: prepare_cached statement error???

[Steve Howard]

OK, I know I've had errors trying that before, but in trying that again
after you said that it did work like that so ignore that part (obviously
that wasn't where the mismatch error was coming from when I did that
before). however "$stmt Error\n" is showing up in the die when it says this:

select description from t_system_symbols where name_space = "COUNTRY"
and
value = ? Error

That's the error, but the error string could be obtained from $DBI::ERRSTR
or the errstr in the statement handle or database handle.

However, you are right in the array is in list context.

Steve H.

-----Original Message-----
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 3:14 PM
To: 'Brennan, Corey '; '[EMAIL PROTECTED] '
Cc: 'Wilson, Doug '; 'Steve Howard '
Subject: RE: prepare_cached statement error???


$sth->execute(@parm) or die ("$stmt Error\n");

Would work just fine.  Since its used in a list context.

-----Original Message-----
From: Brennan, Corey
To: [EMAIL PROTECTED]
Cc: Wilson, Doug; Steve Howard
Sent: 07/19/2001 2:08 PM
Subject: RE: prepare_cached statement error???

Yes this script is currently running under unix with no problems.  That
is
why I am stumped.  But thank you both for the help.

-----Original Message-----
From: Steve Howard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 3:40 PM
To: Brennan, Corey; [EMAIL PROTECTED]
Subject: RE: prepare_cached statement error???


You are saying this worked on Unix? I see one statement that I think
should
be causing you problems with matching the numbers of parameters expected
with the number you have provided:

        $sth->execute(@parm) or die ("$stmt Error\n");

That should be trying to execute with a single value: the length of
@parm. I
doubt that's what you are after. Modify it like this:

        $sth->execute(@parm[0..$#parm]) || die ("$DBI::ERRSTR\n");

(Thanks Michael Chase on this list for teaching me the $# notation)

You can also make your SQL statement a little more readable by using a
qq{}
quote notation, and make it less susceptible to forgetting a back slash
like
this:

$statement =qq{select description from t_system_symbols where
name_space = "COUNTRY" and value = ?};

And when all of that has been correct, I have still run into this error
message from Access (It has nothing to do with Windows or Perl...it's
Access). Sometimes I can get around this bug by going against everything
I've ever been taught and changing the select query to SELECT *
FROM.....

However, when I say that, the only time I work with access is in a
migration
off of access to another database system.

Hope this helps.

Steve H.


-----Original Message-----
From: Brennan, Corey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 12:32 PM
To: [EMAIL PROTECTED]
Subject: prepare_cached statement error???


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