Re: Insert/Update problem working with MSAcess by means of DBD::ODBC

[Simon Oliver]

[EMAIL PROTECTED] wrote:

>   $dbh->do("insert into table2(id,value) values(6,6)")

value is a reservered word - either change it's name or quote it:

  $dbh->do('insert into table2(id,"value") values(6,6)')
or
  $dbh->do('insert into table2(id,[value]) values(6,6)')


-- 
  Simon Oliver