Ok...I lied...one more thing I forgot......if you are using checkboxes, there is a minor bug in Lectora 2005 (hopefully fixed in 2006) that you need to be aware of.....If a user checks a checkbox and then UNCHECKS it before submitting the form you would hope that nothing would be transmitted from the unchecked checkbox. You would hope that....and you would be wrong. It turns out that the following is submitted on checkbox variables where the user has checked the checkbox and then deselected it before submission:~~~null~~~The problem this creates is, this is a 10 character submission....so what you need to do is either test for that in the asp file BEFORE the sql statement is hit and replace it with null (more ASP that I don't want to get into right now) OR make sure that the Access columns that have checkbox data recorded in them have a field width of at least 10 characters. I suppose you could also test for it in Lectora and change the variable contents there. Actually this is more a problem with SQL2000 because if it encounters data larger than the column width it aborts....I think Access will just truncate....but it isn't good nevertheless.Edited By: tekprof on 2005-12-8 22:32:20
