there has to be some place in your logic that has both of them: if this isn't the case, you'll never reach the part where you insert those values in your table....
On Saturday, August 17, 2013 4:39:18 AM UTC+2, Chun-Hung Chen wrote: > > Thanks. > I have tried the custom validator but it does not work as magic. :) > One of the problems is that B.id and C.id are provided individually to the > validator. Thus validator could not get the both ids at the same time, > validator could not validate if B.A_id and C.A_id are identical. > > Niphlod於 2013年8月17日星期六UTC+8上午3時42分36秒寫道： >> >> _before_insert, _after_insert, etc etc are database triggers, not >> validators.... if you want something that tells the user what is wrong, you >> need to code your own validator (or a custom onvalidation in your forms). >> >> On Friday, August 16, 2013 8:56:13 PM UTC+2, Chun-Hung Chen wrote: >>> >>> Or if you have implementations other than my proposal, I would like to >>> have another viewpoint to solve the problem. Thanks. >>> >>> Chun-Hung Chen於 2013年8月17日星期六UTC+8上午2時46分05秒寫道： >>>> >>>> Hi, >>>> >>>> I have a design issue and would like to have discuss with whom is >>>> interested. >>>> >>>> I have 3 tables, A, B, and C, B and C both have a column reference to >>>> A. However, B and C is a many to many relation based on the same reference >>>> to A. >>>> I have created a mapping table D to map B and C. However, in this case, >>>> I could not guarantee that any B and C mapping in D would have the same >>>> reference to A. >>>> I use _before_insert to check and it works but it could not return >>>> useful information to the user. It is just skipped the insertion if B and >>>> C >>>> do not have the same reference to A. I know that I could insert some code >>>> in controller or so to warn or return messages to the user. I am just >>>> curious if it is possible to accomplish such scenario in model definition. >>>> >>>> Thanks. >>>> >>>> Regards, >>>> Chun-Hung >>>> >>> -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
