It doesn't look like there is a method on Template::Plugin::DBI for doing
this, but I think it would be fairly simple to put one in there.  I actually
added a couple of lines to the _connect method of Template::Plugin::DBI just
after the DBI->connect()

$self->{ _DBH }->{ LongReadLen } = 512 * 1024;
$self->{ _DBH }->{ LongTruncOk } = 1; 

(I set LongTruncOk as well so the query does not stop in the middle of
returning rows if a field is bigger than the specified length).

Of course, this is meddling with the inner workings of Template::Plugin::DBI
but it works as a quick fix!

Colin

-----Original Message-----
From: Heilmann, Tim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 10:55 AM
To: [EMAIL PROTECTED]
Subject: [Templates] Using Memo fields with Plugin::DBI 



Is there a way to return large text fields using Plugin::DBI?

Normally I would set the LongReadLen property in DBI but I can't see how to
do this using the Plugin.

thanks,
Tim..
"This communication is intended solely for the addressee and is confidential
and not for third party unauthorized distribution."


_______________________________________________
templates mailing list
[EMAIL PROTECTED]
http://www.template-toolkit.org/mailman/listinfo/templates


Reply via email to