CHECKBOX AND RECORDSET("FIELDNAME") <> ""

[hifiger2004]

Hi Everyone,

I have a problem with my classic asp programming. I think I missed something. I encountered logical error an hour ago. And below is one of the lines in my source code wherein I encountered error.

As looking on the code below, I don't know if what was lacking, because it won't satisfy the condition, and it won't go to the next line "SaveRecord".

I am actually generating a checkboxes, dynamically and the checkboxes are based from the CategoryID. if the checkbox is checked then the value is not equal to "". The question is how am I be able to test the value if it will be checked or not?

btw, in relation to this topic, if you'll have another idea about this matter please let me know. thanks in advance.


if Request(CStr(rsCategory("CategoryID"))) <> "" then
SaveRecord
End If

[jhardman]

I like how you made the checkbox name equal to the category ID from your db.. That is a good idea that I never seem to remember when I make my forms.

Try a quick troubleshooting technique: list all the data passed by your form:

dim x
for each x in request.form
   response.write x & ": " & request.form(x) & vbNewLine & "<br>"
next

Then check to make sure that cstr(rsCategory("categoryID")) returns one of the values of x in the listed form inputs. Does that make sense?

Jared