Hello,
I have a query about 17'000 characters long being glued together from a php-script. It is basically a select over a few tables using joins with some "where"-clauses and alot of "OR" clauses.
Example: and t6.fir="480" or t6.sod1a=8329 and t6.fir="480") or (t6.soc1a=11071 and t6.fir="490" or t6.son1a=11071 and t6.fir="490" or t6.sod1a=11071 and t6.fir="490") or (t6.soc1a=5009 and t6.fir="666" or t6.son1a=5009 and t6.fir="666" or t6.sod1a=5009 and t6.fir="666") or (t6.soc1a=4677 and t6.fir="450" or t6.son1a=4677 and t6.fir="450" or t6.sod1a=4677 and t6.fir="450") or ...
basically the problem can be reduced to this sample query
Select A from table where B=1 and C=2 or D=4 or E=5 or F=6
so, which of the hundreds of OR-clauses did trigger. Is there any way to find out which field trigge
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --