Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Problem with TEXT in DBD::Sybase
Date: Jul 20 2001 9:06PM
tao starbow writes:
> I am using DBD::Sybase ( version 0.23 ) to interface
> with a Sybase-backed application. Everything is
> working well except for one table which includes a
> TEXT field. If I try to update the TEXT field (
> "update table set field='new text' where key='key'" ),
> it looks fine when I do a select, but the application
> ignores it.
> The only way I can get the application to acknoledge a
> change is to do an insert/select from another valid
> table entry ( "insert into table ( select 'key' as
> key, field from table where key='key2'" ). Strangly
> enough, when I do a select here, it looks identical to
> the results of the method above.
This seems to me to be a problem with the application, and not with
your code, or with DBD::Sybase...
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
firstname.lastname@example.org - email@example.com
International Sybase User Group - http://www.isug.com