How to validate an array element?

isDefined() doesn't work with array elements. Set a variable to the array element and then test that instead.

I'm not able to set a variable to the array element if it's undefined. I tried it and I'm still getting CF errors. I think I'm just not thinking of the best way to handle this, but I'm stumped.

This is what I'm trying to accomplish:
I have a form with a section with a bunch of checkbox fields.
I'm retrieving the fields which were selected using a query. I know which numbers were checked, but now I want to have those fields checked off when the user goes into the form to edit their records.

I just need to either see if the query returned that specific value or not, and either check or not check the box.

Then why not just use a list and loop over it checking the checkboxes which have a number in the list? Create the list (a string of numbers delimited by commas) using the query. To determine whether to check a checkbox or not, you could use listfind.

Quote: Originally Posted by acoder Then why not just use a list and loop over it checking the checkboxes which have a number in the list? Create the list (a string of numbers delimited by commas) using the query. To determine whether to check a checkbox or not, you could use listfind.

I'll give that a shot. It's so easy in my head, I just cant get the sql/cf code down right.

I'm too used to coding in proprietary systems....I need to get better acquainted with sql/cf.

If you get stuck, post your attempted code, and I can suggest changes.