2. PHPRunner General questions
  3. Multi Field Checking
This topic is locked

Multi Field Checking

 		8/20/2006 11:09:03 AM
PHPRunner General questions
K
 ke5rs author

Hello PHP Runner folks

How do I prevent multiple records of the same description with same properties.

I would like to prevent same description, size & color added to a table
Field Description ="wagon"

Field color ="Red"

Field size ="36 inch"
More wagons added are fine as long as they are a different size or color but I do not want any more Red 36" wagons added to my table.
Thank you

John
T
 		thesofa 8/20/2006

Hello PHP Runner folks

How do I prevent multiple records of the same description with same properties.

I would like to prevent same description, size & color added to a table
Field Description ="wagon"

Field color ="Red"

Field size ="36 inch"
More wagons added are fine as long as they are a different size or color but I do not want any more Red 36" wagons added to my table.
Thank you

John



Set the key value in step 5 where you decide the pages to build, select all three field as a key field, this will give you a primary key of Description, Colour and Size
K
 		ke5rs author 8/20/2006

I do have 2 keys selected in step 5 and it allows adding multipule records still but when I want to delete one, it deletes both. Interesing?

Do I need to make them keys in the MySQL Database too?

Thanks,

John
T
 		thesofa 8/20/2006

I do have 2 keys selected in step 5 and it allows adding multipule records still but when I want to delete one, it deletes both. Interesing?

Do I need to make them keys in the MySQL Database too?

Thanks,

John



I think so, it will speed up searching if you create and index using those three fields too.
K
 		ke5rs author 8/20/2006

I had another key that I over looked in my database and I fixed that and your right with the step 5 keys.

It is working now.

Thank you

John