data type conversion - Overflow?

[Scott Taylor]

Can someone please point out what I am doing wrong here?
I get this error:
DBD::InterBase::st fetchrow failed: Overflow occurred during data type 
conversion.
-conversion error from string "0"

when trying to do this (connection and all else is OK):

$SQL = "SELECT B, TRKID, TRLID, HAULID, DESCRIPTION, STICKET1, DTICKET1,
                ACTUAL_GR, ACTUAL_TA, LOADDATE, DUMPDATE, SPECIES, MATERIAL,
                DESTNAME, DISPNO, COMMENSW
                   from DISP_LEG
                      where STICKET1 >= $thistik and
                            LOADDATE >= $stdate and
                            LOADDATE <= $enddate";
$cursor = $dbh->prepare($SQL);
$cursor->execute;

while ( @columns = $cursor->fetchrow ) {
     print ( ( map { "[$_]" } @columns ) , "\n");
}

Or is there a better way?
Thanks.

--
Scott Taylor
Systems Administrator
DCT Chambers Trucking Ltd.


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]