in reply to Getting error when selecting from database

You don't say what type of column NOTES is, but if it's potentially large (like a BLOB, (LONG)TEXT or MEMO field) then you need to play with DBI->connect's LongTruncOk and/or LongReadLen attributes.

$dbh = DBI->connect( 'dbi:ODBC:StockDB', '', '', { LongTruncOk => 1, LongReadLen => 1024 * 64, # 64K }, ) || ...

    --k.


Replies are listed 'Best First'.
Re: Re: Getting error when selecting from database
by Anonymous Monk on Jun 12, 2002 at 22:31 UTC
    It is a memo field. It's pretty long.