cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <>
Subject RE: Getting text fields with SQL processor
Date Mon, 21 Aug 2000 17:41:34 GMT
On Mon, 21 Aug 2000, Mauro Canal wrote:

> Hello
> the problem is that the JDBC-Driver for MySQL returns always a 
> BLOB for a TEXT-Datatype.
> So this is interpreted as Object in the ColumnFormatter Class, even 
> if you set the column type to text.
> The only work around I found is to have "RTRIM(column) AS myColumn"
> in my SELECT statements. This gives me a VARCHAR-Type and the 
> ColumnFormatter works again.

the sql logicsheet is patched to avoid this problem. i'd use that
instead. i welcome patches to sqlprocessor to fix it there, but i'm not
going to put time into it.

- donald

View raw message