Re: Cannot insert into MS Access Memo field with DBI

[drewbert2000]

I managed to find a solution to this problem without using another module (but thank you for the suggestion anyway). I imagine that not many people are writing TO an Access DB which is probably why there are no posts regarding this exact situation. Here is the code to make it work:

my $dbh = DBI->connect('DBI:ODBC:whatever', 'whatever', 'whatever');

my $sql = q{ 
 INSERT INTO tblGuestbook
  (name, email, country, website, publicmessage, privatemessage, IP)
 values
  (?,?,?,?,?,?,?)
 };
 
my $sth = $dbh->prepare($sql);

# Do this line for each one being inserted into a Memo field.
$sth->bind_param( 4, $publicmesage, DBI::SQL_LONGVARCHAR );
$sth->bind_param( 5, $privatemesage, DBI::SQL_LONGVARCHAR );

$sth->execute($name,$email,$country,$website,$publicmessage,$privateme
+ssage,$ENV{REMOTE_ADDR});

$sth->finish;
$dbh->disconnect;

Hope that helps someone out there... =) Drewbert2000 08-Jan-2002 ===========