Query returns -1 if row present (DBI, SQL Server 2000)
- From: int eighty <xcdx80@xxxxxxxxx>
- Date: Mon, 29 Oct 2007 19:16:33 -0000
Hello,
I am using the DBI module to interface with a SQL Server 2000 database
-- connection, INSERT, UPDATE, and SELECT (when 0 rows exist in
resultset) are fine. However, if the resultset contains a row, a
value of -1 is returned. The query is very simple:
my $sth = $dbh->prepare(q{SELECT TOP 1 id FROM host WHERE ip = ?});
$sth->execute($ip);
print "Looked up $ip: " . $sth->rows . " ($DBI::errstr)\n";
if ($sth->rows == 0) {
# do something
}
elsif ($sth->rows > 0) {
# do something else
}
else {
# error
}
I do not believe this to is a permission problem with SQL Server as
the initial SELECT runs and jumps properly when $sth->rows is 0.
However the code always ends up in the else block if a row is returned
from the initial SELECT. The SELECT query also runs fine in Query
Analyzer when entered manually. Oh, it may also be worth mentioning
that $DBI::errstr is empty after the execute call for the initial
SELECT query.
TIA.
.
- Follow-Ups:
- Re: Query returns -1 if row present (DBI, SQL Server 2000)
- From: J. Gleixner
- Re: Query returns -1 if row present (DBI, SQL Server 2000)
- Prev by Date: Re: Regex Help
- Next by Date: Re: Query returns -1 if row present (DBI, SQL Server 2000)
- Previous by thread: Problem getting command output
- Next by thread: Re: Query returns -1 if row present (DBI, SQL Server 2000)
- Index(es):
Relevant Pages
|
|
