sharad.jash
New Member
How to stop inserting duplicate data in a list depending upon certain criteria ??
Following are techniques I have tried but I didn't get the results i expected.
1. Added a php form plugin which will run @ the "End of form submission"
Before insertion of a row I have checked certain values from tables using sql query count() function, and if count() returns more than 0,I ended up return false. -- It doesn't runs all the times.
2. I added a trigger at db table making certain columns constraints.it restricts the user to added a row. -- But the problem is it shows the entire sql query or procedure As ERROR in application.
Any Ideas how to resolve this issues.
Is I'm doing something wrong ?
Thanks in advance...
Following are techniques I have tried but I didn't get the results i expected.
1. Added a php form plugin which will run @ the "End of form submission"
Before insertion of a row I have checked certain values from tables using sql query count() function, and if count() returns more than 0,I ended up return false. -- It doesn't runs all the times.
2. I added a trigger at db table making certain columns constraints.it restricts the user to added a row. -- But the problem is it shows the entire sql query or procedure As ERROR in application.
Any Ideas how to resolve this issues.
Is I'm doing something wrong ?
Thanks in advance...