college_amy
Regular
- Joined
- Jan 3, 2004
- Messages
- 83
Hi.
I have an app that shows a registered user their information they registered with.
One of the tables that is being read has some 35 fields in it. Of that 35 fields, 3 are definite to have information in them, the other 32 will either have a null value or a yes value depending on which checkbox was selected during registration.
What I would like to know is if there is a way to loop through the fields with the yes value in them to display only those fields or do I need to check each field specifically in which I would use an if/then/else statement to display the information? I think the latter of the two will make the app have alot of useless programming if I do it that way.
I know that I can write a SQL statement to check specific fields for Yes values, but I want all the fields with a yes value.
Any help is appreciated.
Thanks,
Amy
I have an app that shows a registered user their information they registered with.
One of the tables that is being read has some 35 fields in it. Of that 35 fields, 3 are definite to have information in them, the other 32 will either have a null value or a yes value depending on which checkbox was selected during registration.
What I would like to know is if there is a way to loop through the fields with the yes value in them to display only those fields or do I need to check each field specifically in which I would use an if/then/else statement to display the information? I think the latter of the two will make the app have alot of useless programming if I do it that way.
I know that I can write a SQL statement to check specific fields for Yes values, but I want all the fields with a yes value.
Any help is appreciated.
Thanks,
Amy