hello,
i'm running my script on a win2000 box called eggpayorteam. i have
established a ODBC system DSN name of "eggpayorteam" and have set the
default database to "eggsupp". when i run my queries below i get errors,
noted further below. when i remove "use eggsupp" it runs fine. is this
strange behavior? and why is this happening?
sth = $dbh->prepare("
use eggsupp
select count(fileid) as number from filesupp fs
where datecreated >= '$past' and datecreated <= '$today'
");
$sth->execute;
while( my @data = $sth->fetchrow_array)
{
$total_num = $data[0];
print "$total_num\n\n\n";
}
###### query 2#
$sth = $dbh->prepare("
use eggsupp
select count(fileid), crashtypedescr
from filesupp fs join crashtype ct on fs.crashtype = ct.crashtypeid
where crashtype <> ''
and datecreated >= '$past' and datecreated <= '$today'
group by crashtype,crashtypedescr
");
$sth->execute;
---------------------
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Invalid
cursor
state (SQL-24000)(DBD: dbd_describe/SQLNumResultCols err=-1) at
C:\perl\scripts\
crash_pie.pl line 59.
DBD::ODBC::st fetchrow_array failed: (DBD: no select statement currently
executi
ng err=-1) at C:\perl\scripts\crash_pie.pl line 61.
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Invalid
cursor
state (SQL-24000)(DBD: dbd_describe/SQLNumResultCols err=-1) at
C:\perl\scripts\
crash_pie.pl line 77.
DBD::ODBC::st fetchrow_array failed: (DBD: no select statement currently
executi
ng err=-1) at C:\perl\scripts\crash_pie.pl line 79.
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
