Skip to main content
A
Anonymous
December 7, 2006
Answered

8.02 Insert issue with blank radio buttons

  • December 7, 2006
  • 2 replies
  • 301 views
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?
This topic has been closed for replies.
Correct answer Newsgroup_User
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

2 replies

N
Newsgroup_UserCorrect answer
Inspiring
December 9, 2006
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
N
Newsgroup_User
Inspiring
December 7, 2006
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?
>
A
Anonymous
December 7, 2006
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.
Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices