What are your previous/following lines on that code? I'de like to see it more
complete in order tyo find possible errors. I've used perl to manage really
large tables (much larger than yours) with no problem. Also, which
database/driver are you using?
Paco
----- Original Message -----
From: John DePasquale
To: activeperl@listserv.ActiveState.com
Sent: Thursday, August 30, 2007 9:14 PM
Subject: select statement fails
greetings all,
I think I have a case of too much data being returned to a perl script, but
I'm not certain.
using perl 5, DBI:ODBC, MS-SQL and IIS 6:
executing the following code:
$sth = $dbh->prepare("select field1 from table ") || &failed( "prep failed" );
$exec = $sth->execute() || &failed( "exec failed" );
correctly returns 170 rows of data. but if I replace the field name with *,
as in:
$sth = $dbh->prepare("select * from table ") || &failed( "prep failed" );
$exec = $sth->execute() || &failed( "exec failed" );
it returns no data, but neither does either statement fail. the table
contains 160 fields.
can the script be overwhelmed with too much data, and/or are there limits of
field counts or return-set size, and if so can they be managed? I have a hard
time believing perl can't handle this table.
any ideas greatly appreciated. thanks.
John DePasquale
IT Manager
Law Offices of James Sokolove
1340 Centre Street - Suite 102
Newton, MA 02459
Direct line: 617-467-6932
Fax: 617-964-4336
This email is intended solely for the use of the individual to whom it is
addressed and may contain information that is privileged, confidential or
otherwise exempt from disclosure under applicable law. If the reader of this
email is not the intended recipient or the employee or agent responsible for
delivering the message to the intended recipient, you are hereby notified that
any dissemination, distribution, or copying of this communication is strictly
prohibited. If you have received this communication in error, please
immediately notify us by telephone and return the original message to us at the
listed email address. Thank You.
------------------------------------------------------------------------------
_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs