View Full Version : Application uses a value of the wrong type ...

12-16-2006, 01:43 AM
Hello all. I have an online timecard system, which has a different page for each day of the week. I am getting the following error when I try to insert data into my DB. I know it's not the code, because I get the same error on all pages when I choose a specific value from a drop-down box. I noticed that when I change the value of the drop-down box option to 50 char. or less, it seems to work fine. I have the field length in the DB set to 75 and still no luck. Is there a maximum length for drop-down boxes? Can this be changed?

Here is the error:

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

/Timesheet/ts_enterSat.asp, line 152

Thanks in advance,


12-16-2006, 01:59 AM
Actually, I figured it out. I was looking at the size of the field that populates the dropdown box, and not the size of the field that the data was getting inserted in. I changed that size, and everything works fine.

That means it's time to go home.... ;o)