an ON INSERT trigger usually happens at the moment you're about to insert a new record. This will make inserting the same row over and over just an update to the row, instead of an insertion of the new one. With that in place, you can skip your own validation and just insert the whole file, the database will take care of updating an existing or inserting a new one. Now, every serious database has it, but as far as I recall in Mysql is not possible. However, mysql has "UPSERT" . You can read about it on the manuals, and evaluate all pros and cons.
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
