two-field primary key update issue

[Greg Donald]

I have a table with a two-field primary key, it's structure is like this:

CREATE TABLE extraFieldOptions (
  fieldID tinyint(3) unsigned NOT NULL default '0',
  fieldOption varchar(16) NOT NULL default '',
  fieldValue varchar(16) NOT NULL default '',
  PRIMARY KEY  (fieldID,fieldOption)
) TYPE=MyISAM;

I can't figure out how to update the 'fieldValue' for a given row, here is my 
query:

update
        extraFieldOptions
set
        fieldValue = 'horizontal'
where
        fieldID = '2'
and
        fieldOption = 'alignment' 

mysql> update extraFieldOptions set fieldValue = 'horizontal' where fieldID 
= '2' and fieldOption = 'alignment';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

MySQL doesn't produce an error.. but I think maybe it's the 'and' in my where 
clause that isn't working.  I have looked high and low for an example of such a 
query but cannot find anything.  Any help would be greatly appreciated.  Thanks.

-- 
Greg Donald




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]