http://www.perlmonks.org?node_id=491809


in reply to Re^3: Accessing MS-Access memofield via DBI
in thread Accessing MS-Access memofield via DBI

The solution is quite simple:
$sth->bind_param(1,$var,&{"DBI::$coltype"}());

But the question is why my version (&{"DBI::$coltype"}) runs in a single script and why it doesn't work after splitting into script and module...

Replies are listed 'Best First'.
Re^5: Accessing MS-Access memofield via DBI
by dorianwinterfeld (Acolyte) on Oct 03, 2005 at 04:13 UTC
    I had the same problem as you and I duplicated your solution, with the same complication. When the insert code is in a different package than the calling routine it didn't work. Must be a namespace issue. If you resolve it please let me know. In the meantime thank you, thank you to everyone in this thread. I was going nuts with this problem.
[reply]

In Section Seekers of Perl Wisdom