All,

My Environment is...
NT 4.0
MS SQL 6.5
ActivePerl v5.6.1

I am trying to run a select statement but one of the fields that I'm trying
to get is a Text datatype.
If I remove that field from my select statement everything works fine.

the error message I get is...
DBD::ODBC::db selectall_arrayref failed: [Microsoft][ODBC SQL Server
Driver]String data, right truncation 
(SQL-01004)(DBD: st_fetch/SQLFetch (long truncated) err=1) at
C:\TEMP\test-disdplay.pl line 27.

Can anyone help me figure out how to get at that data or is there a
different datatype that I can use that 
can hold more then 255 (I'm talking 1-3 pages of text) characters?

Thanks,
Brad


**********************************************************************
Notice:  The area code for the Wal-Mart Bentonville General 
Office in the US has changed from 501 to 479.  Please make
sure that you are dialing 479 when making calls to any 
General Office location.

**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to 
whom they are addressed.  If you have received this email
in error destroy it immediately.
**********************************************************************
             Wal-Mart Stores, Inc. Confidential
**********************************************************************

Reply via email to