Hi to all,
I have an ASP page that has 10 fields (drop-down menus) it is a sort of a form. Depending on what you choose, the information will extracted from the DB. Note that you have the option either choosing all the ten fields or even one, or two , or three.
My page now contains only 4 fields and it is working perfect. My code has about 16 If statements in order to handle all scenarios and possibilities. In other words, some users will fill up one field and some will fill 9 or 10. My question is there any other ways to write the queries so that I do not have to write a lot of If statements. I am talking about more than 800 If statements since there are 10 fields to fill so the number of the scenarios and possibilities are very very very large. Please advise if you have any suggestions. I appreciate your help and assistance.
any further information needed will be provided…
Thanks and regards…
Khaled
