Database Bounce

[raouleduke]

I am trying to do make it so that certain records, cannot be put in the database, I think that I need to create a new table and put the customers that I don't want in the database in it. But how do I make it so that it will check it and not put in certain records.

Thanks for your help.

[Pig]

If you have a table with all of the names you don't want in there, then you can just query the database against it. If you get a result, then kill the script, otherwise continue.

[Sxooter]

If you're using an active database like postgresql or interbase, you can program a before trigger that will fire on each insert and check to see if the record being inserted is on a list of records not to be inserted (keep that list in a secondary table, like pig suggested).

If you're using MySQL you'll have to program it into your application logic.