Posting you table difinitions and queries would be helpful.
-------------------------------- Olexandr Melnyk, http://omelnyk.net/ 2007/2/8, Alicia Amadoz <[EMAIL PROTECTED]>:
Hello, I am trying to update two fields of a table that are a composed foreign key to another table. These fields cant be updated with this kind of warning: Warning | 1292 | Truncated incorrect DOUBLE value: 'A05' Both tables are InnoDB and I have tried with all types of constraints, ON UPDATE CASCADE, SET NULL and NO ACTION, as foreign key constraints of the table that I want to update. Any help or idea of how can I solve this problem? Thank you very much in advance, Alicia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]