DK wrote: > Hello > > I get following msql error "#1062 - Duplicate entry '4-0' for key 1 " > when I try to run following INSERT statement. > > Suggesting that each user can have only one filter. > What am I doing wrong here? > > INSERT INTO `dbmail_filters` ( `user_id` , `filter_id` , > `filter_field` , `filter_value` , `mailbox` ) > VALUES ( > '4', '0', 'Subject', 'casino', 'INBOX/Spam' > )
Demi, This means that there is already a filter_id:0 for user_id:4. The filter_id values has to be unique for each user. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
