Microsoft OLE DB Provider for ODBC Drivers error '80040e21' 1

[Slippenos]

I get this error

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

When I attempt to update a table within my database with a null 'Yes/No' field.

My html code is as follows:

<input type = "checkbox" name = "Sample" value=1>

And the field properties are set to Yes/No | On/Off

I cannot set the MSAccess field to 'allow zero-lengths'.

How can I submit my form will null Yes/No fields?

 

[Sheco]

Did you try setting the default value to 'No' ??

 

[Slippenos]

I changed the format to read 'Yes/No' and I changed the default value to No ... to no avail.

Any other suggestions?

 

[Sheco]

Are you sure it is a problem with this particular field?

Does your code work OK if it is not null? Lets see the part of the code where you interact with the database.

 

[Slippenos]

<%

Set Rs = Server.CreateObject( "ADODB.Recordset" )
Rs.Open "tblDataRequests", "MikeyDRF", adOpenKeySet, adLockPessimistic, adCmdTable
Rs.AddNew

Rs( "Sample" ) = Request.Form( "Sample" )

Rs.Update
Rs.Close
Set Rs = Nothing

%>

 

[Sheco]

Try this:

IF Len(Request.Form("Sample")) > 0 THEN
  Rs( "Sample" ) = Request.Form( "Sample" )
END IF

Or this:

Rs( "Sample" ) = CBool(Request.Form("Sample"))

 

[Slippenos]

They both worked as I wished. Thank you very much. If I might ask, though ..

What does the Cbool method do?

-Mike

 

[Slippenos]

n/m .. I see that now. Thanks again.

 

[Sheco]

I'm glad it worked out for you and thanks for the star!