Return-Path: Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 45462 invoked from network); 14 Mar 2000 16:53:36 -0000 Received: from mail.egios.co.kr (HELO egiosmail.egios.com) (211.47.160.32) by locus.apache.org with SMTP; 14 Mar 2000 16:53:36 -0000 Received: from synctank.com (sitg26.ITGINC.COM [199.35.46.36]) by egiosmail.egios.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id G40FF4LJ; Wed, 15 Mar 2000 01:54:40 +0900 Message-ID: <38CE6F4E.C7899C1C@synctank.com> Date: Tue, 14 Mar 2000 06:56:46 -1000 From: Russell Castagnaro Reply-To: russell@synctank.com Organization: SyncTank Solutions X-Mailer: Mozilla 4.72 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: cocoon-users@xml.apache.org Subject: Re: SQLProcessor - MySQL - TEXT type fields problem References: <005b01bf8d82$c11a1480$752b8ec6@webcybernetics.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N Try selecting the text column using a substring. if the columnis named col1 substring(col1,0). Rob Parker wrote: > I'm using cocoon 1.7 with Apache/Jserv1.1 etc and MySql. I amrunning a query > on a 'TEXT' type column. The SQLProcessor seemsto return a Java object > reference rather than the text. Any suggestions? BTW the same code works fine > if the column is of type 'varchar'.... Rob Parker > Technical Director > Web Cybernetics Pty Ltd > Level 3, IBM Tower > 60 City Road > Southgate, Vic. 3006 > Australia Phone: +61 3 9626 2489 > Fax: +61 3 9699 5477 > Mobile: 0419 135 193 > e-mail: robert@webcybernetics.com > Web: www.webcybernetics.com -- Russell Castagnaro Chief Mentor SyncTank Solutions http://www.synctank.com Earth is the cradle of mankind; one does not remain in the cradle forever -Tsiolkovsky