Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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

by rjberry (Novice)
on Oct 06, 2008 at 12:59 UTC ( #715563=note: print w/ replies, xml ) Need Help??


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

I'm having the same darn problem but the bind_param line isn't helping. This is my code:

use DBI; $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb);' + . "dbq=$db_path"); my $note = "Order"; $sth = $dbh->prepare("INSERT INTO tblCustomer ( BranchID, LastName, Fi +rstName, Street, Town, County, PostCode, PhoneNumber, Email, Note ) SELECT ? AS Expr1, ? AS Expr2, ? AS Expr3, ? AS Expr4, ? AS Expr5, ? A +S Expr6, ? AS Expr7, ? AS Expr8, ? AS Expr9, ? AS Expr10; "); ## MSAccess is a piece of crap so you have to do this to fix anything +inserted into ## a memo field ... $sth->bind_param( 10, $note, DBI::SQL_LONGVARCHAR ); $sth->execute( 'L1', $secondname, $firstname, $order->{addresses}->{delivery}->{street}, $order->{addresses}->{delivery}->{city}, $order->{addresses}->{delivery}->{county}, $order->{addresses}->{delivery}->{postcode}, $order->{phone}, $order->{email}, $note ) or die "Could not update DB!";

Anyone have a clue? The error message just says that the SQL is improperly formatted, which it does not do if I take out the 'note' line, which is the Memo.


Comment on Re^4: Cannot insert into MS Access Memo field with DBI
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (6)
As of 2015-07-05 13:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (67 votes), past polls