On 2009-03-02 20:04:02 -0800, Moderator wrote:
^^^^^^^^^
first off, I don't think choosing the nick
name "Moderator" is an especially bright move. Some might think you are
claiming to be the moderator of the list.
> One of our tables awb_msg has the field name 'text' and when I try to
> use the DBI to do a select it prompts an error. How can I do this.
>
> I can't change the field name as it is in a production environment and
The error below doesn't look like is has anything to do with the field
name.
> DBD::ODBC::st fetchrow_arrayref failed: [Microsoft][ODBC SQL Server
> Driver]Strin
> g data, right truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long
> truncated DBI
> attribute LongTruncOk not set and/or LongReadLen too small) err=-1)
> at ./dbi.pl
> line 34.
It says that it must truncate a string (presumably the contents of
"text"), but isn't allowed to (LongTruncOk not set). So the problem
almost certainly not the name "text" but the size of the data.
Read perldoc DBI for information about LongTruncOk and LongReadLen.
> Please guide me how I can do this.
The first step is to actually read the error message.
hp
--
_ | Peter J. Holzer | Auf jedem Computer sollte der Satz Ludwigs II
|_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich
| | | [email protected] | bleiben, mir und andern."
__/ | http://www.hjp.at/ | -- Wolfram Heinrich in desd
pgp3oxfCAm8Eh.pgp
Description: PGP signature
