Beefy Boxes and Bandwidth Generously Provided by pair Networks Russ
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

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

by Anonymous Monk
on Jul 16, 2009 at 14:38 UTC ( #780728=note: print w/ replies, xml ) Need Help??


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

I don't know if something changed in subsequent versions of DBI:ODBC, but I got this to work only after counting the order of my fields starting with 1 instead of 0. I.E. for the above example to work for me it would need to be:

$sth->bind_param( 5, $publicmesage, DBI::SQL_LONGVARCHAR ); $sth->bind_param( 6, $privatemesage, DBI::SQL_LONGVARCHAR );


Comment on Re^2: Cannot insert into MS Access Memo field with DBI
Download Code
Re^3: Cannot insert into MS Access Memo field with DBI
by auntie_anne (Initiate) on Jul 22, 2009 at 18:42 UTC
    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.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (15)
As of 2014-04-24 13:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (565 votes), past polls