flowscript, MySQL and blobs

[Robert Clarke]

Hello,

I have the following flowscript:

    var dbconn = Database.getConnection("intranetdata");
    result = dbconn.query("SELECT meta_title, meta_description FROM
intranet_meta WHERE meta_id = ?", [meta_id]);
    dbconn.close();

    var title = result.rows[0].meta_title;
    var description = result.rows[0].meta_description;


    form.getWidget("title").setValue (title);
    form.getWidget("description").setValue (description);

This is throwing the error:

Java class "[B" has no public instance field or method named "text".

Presumably this is because the database field meta_description is a blob.
How can I retrieve it as a normal string?

I'm using Cocoon 2.1.3 and the database is MySQL.

Thanks for any help,

Rob

#############
Robert Clarke

Web Systems Developer
Bradford College


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]