8.02 Insert issue with blank radio buttons

[Guest]

I've found a weird bug. With 8.02 using ASP VB script, if I have two radio buttons on a page (opt in / opt out) and both are unchecked by default, when the form is submitted to an access database, and nothing was checked, I'm getting the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
[Microsoft][ODBC Microsoft Access Driver]Invalid string or buffer length


But, if you check one of the boxes, things work. This is something that has never happened before and I've developed MANY forms. The database field is a test field with a length of 50.

What's going on?

[Newsgroup_User]

Does that column accept null values?

> I've found a weird bug. With 8.02 using ASP VB script, if I have two radio
> buttons on a page (opt in / opt out) and both are unchecked by default, when
> the form is submitted to an access database, and nothing was checked, I'm
> getting the following error.
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
> [Microsoft][ODBC Microsoft Access Driver]Invalid string or buffer length
>
>
> But, if you check one of the boxes, things work. This is something that has
> never happened before and I've developed MANY forms. The database field is a
> test field with a length of 50.
>
> What's going on?
>

[Guest]

Yes, it does.

Like I mentioned. I've done a million forms over the years. This is the first form using the new 8.02 server behaviors.

Required = No
Allow Zero Length = Yes

I've never seen anything like it.

[Newsgroup_User · Accepted solution]

Jim_Deitzel wrote:

> I've found a weird bug. With 8.02 using ASP VB script, if I have two radio
> buttons on a page (opt in / opt out) and both are unchecked by default, when
> the form is submitted to an access database, and nothing was checked, I'm
> getting the following error.
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
> [Microsoft][ODBC Microsoft Access Driver]Invalid string or buffer length
>
>
> But, if you check one of the boxes, things work. This is something that has
> never happened before and I've developed MANY forms. The database field is a
> test field with a length of 50.
>
> What's going on?
>
"HTML strict" requires that one radio button per group be checked by
default.
Mick