Re: DBI or Mysql UPDATE error?

Rudy Lippan <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
On Wed, 18 Aug 2004, Neil Watson wrote:

> Error:
> error: dbh2 = Apache::DBI::db=HASH(0x87011f0) Couldn't execute
> statement: UPDATE hardware SET
> description='Workstation',
> model='',
> hwtid='1',
> serial='AD750-1489164',
> poid='',
> uid=''
> WHERE hid=2; Unknown column 'model' in 'field list' at
> /var/www/itiv/htdocs/admin/comp/insert.mas line 667.
> 

Does this work though the mysql shell?  Did you try a DBI->trace(9) on the 
statement? Are using the correct database, and are you hitting the right 
database server?


Rudy


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.