Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^3: Cannot insert into MS Access Memo field with DBI

by auntie_anne (Initiate)
on Jul 22, 2009 at 18:42 UTC ( #782408=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Cannot insert into MS Access Memo field with DBI
in thread Cannot insert into MS Access Memo field with DBI

This sounds crazy but I had this problem trying to put a string into the ms access memo field and after pulling out my hair I got the data in by putting it in an array. edit: array is NOT NEEDED. just do the blob support i.e.:

$dbh->{LongReadLen} = 20000; #(change 20000 to your needs)
$dbh->{LongTruncOk}=1; #(truncate at 20000)

***update: the blob support fixes it for going in too so the array is not needed. you can put the big string in if LongReadLen is active. d'oh.


Comment on Re^3: Cannot insert into MS Access Memo field with DBI

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://782408]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2014-09-15 05:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (145 votes), past polls