Re: MySQL constraint question

2005-02-23 Thread Gerald Taylor
Thanks for these answers. I can now write this in the application and be OK with it without that nagging feeling that somebody will say upa if you just put xxx in the database then you could filter all that in your query. If it ever happens I can say, ah yes but when I wrote that we were only

Re: MySQL constraint question

2005-02-22 Thread SGreen
Gerald Taylor [EMAIL PROTECTED] wrote on 02/18/2005 10:18:29 AM: I have a database thats full of ingredients that are placed in various categories. and then there are mixtures that are allowed to be labelled with a certain grade based on the quality and composition of the ingredients it is

Re: MySQL constraint question

2005-02-22 Thread Martijn Tonies
I have a database thats full of ingredients that are placed in various categories. and then there are mixtures that are allowed to be labelled with a certain grade based on the quality and composition of the ingredients it is comprised from. But the formulas are not always the same, as

MySQL constraint question

2005-02-18 Thread Gerald Taylor
I have a database thats full of ingredients that are placed in various categories. and then there are mixtures that are allowed to be labelled with a certain grade based on the quality and composition of the ingredients it is comprised from. But the formulas are not always the same, as long as