AnsweredAssumed Answered

Identical pattern calculation

Question asked by ultranix on Jan 6, 2015
Latest reply on Jan 6, 2015 by philmodjunk


Identical pattern calculation


I have a questionaire of 30 questions, 360 possible answers in total. I want to be able to have a portal aside to questionaire, where all other questionaires with the same answers are stored. As it would be way too hard to set 30 relations in manage database, I thought of another solution, like answer_score. and then assign to each of the answers numbers in sequence 1, 2, 4, 8, 16, 32, 64, 128, 256, 512 and so on. So later if you add them all, you will have unique score and therefore you could match using that field with another table occurence and display questionaires with same results.

It all looks great up to this point. But after 37th number in the sequence - 68719476736 - all other numbers in the sequence are E+11 and higher. I tried making initial number 0,000001 (and then sequence continues like 0,000002, 0,000004, 0,000008, etc.), but it only solves the issue up to 10 more numbers. And I need 360.

How could I solve it? Keep in mind, that such method with sequence of numbers is one of the possible options. If you know any other or easier, which solve the problem - to match identical questionaire results - I would be glad to read it.