![]() |
romaldus 9/28/2016 |
How do I get around the empty field with Prevent Duplicate Values? Lookup Wizard "Please select" message error "Field should not contain a duplicate value" Thanks
SELECT product FROM products_table WHERE product_id <> ''
SELECT DISTINCT product FROM products_table |
J
|
jrbr author 9/29/2016 |
In phprunner lookup, click create new query button to get rid of / ignore empty fields. For example in mysql: SELECT product FROM products_table WHERE product_id <> ''
SELECT DISTINCT product FROM products_table
|
![]() |
romaldus 9/29/2016 |
If you want to PREVENT duplicate values but ALLOW duplicate empty strings ,
|
J
|
jrbr author 9/30/2016 |
If you want to PREVENT duplicate values but ALLOW duplicate empty strings ,
|