Checkbox not saving to DB 
Author Message
 Checkbox not saving to DB

I have several checkboxes on a form. One is EmailUpdates, the others are
a set of checkboxes for potential problems with the users application.

If I check EmailUpdates for a specific record, move to another record
and return to the original record the checkbox is not checked. Looking
at the table directly the field value is False.

If I check any or all of the Problems checkboses, move to another record
and return to the original record the checkboxes are checked as
expected.

So, for some reason the EmailUpdate field appears as if it's not getting
updated.

EmailUpdates and the Problems fields are defined as bit data type with
length = 1.

The properties for all items under the Data tab are exactly the same for
EmailUpdates and Problems checkboxes (except Control Source, of course)

Any ideas ?

Ed

--

Do you need a Web-based Content Publishing System ?

Ed Swartz : 978-772-0888
Web Development : ASP, PHP, MySQL, and SQL Server

http://www.***.com/

Ed's List : http://www.***.com/



Sat, 25 Jun 2005 01:56:59 GMT
 Checkbox not saving to DB

Ensure this field is a Yes/No data type. A true (checked box) will
return -1; False returns 0.
Ensure the bound field name is spelled correctly. At minimum recreate the
checkbox; any previous entries will be retained as the data will be pulled
from the underlying table.


Quote:

> I have several checkboxes on a form. One is EmailUpdates, the others are
> a set of checkboxes for potential problems with the users application.

> If I check EmailUpdates for a specific record, move to another record
> and return to the original record the checkbox is not checked. Looking
> at the table directly the field value is False.

> If I check any or all of the Problems checkboses, move to another record
> and return to the original record the checkboxes are checked as
> expected.

> So, for some reason the EmailUpdate field appears as if it's not getting
> updated.

> EmailUpdates and the Problems fields are defined as bit data type with
> length = 1.

> The properties for all items under the Data tab are exactly the same for
> EmailUpdates and Problems checkboxes (except Control Source, of course)

> Any ideas ?

> Ed

> --

> Do you need a Web-based Content Publishing System ?

> Ed Swartz : 978-772-0888
> Web Development : ASP, PHP, MySQL, and SQL Server

> http://www.SandyPondConsulting.com

> Ed's List : http://www.SandyPondConsulting.com/EdsList.cfm



Sun, 26 Jun 2005 10:58:58 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Master DB not in Enterprise manager 7.0

2. Mirror DB to another server, not to another disk

3. DB corrupt after RESTORE, but not before

4. DB not using available space

5. DB records not saving!

6. DB PROCESS Died Or not enabled

7. Error -261 - Can not DB

8. EM db properties page not updating

9. iif not recognize with SQl Server using OLE DB

10. HELP: 7.1 DB Engine performance (not an easy one)

11. URGENT HELP - keeping integrity while not sharing the same DB

12. CRASH in debug mode (not in design mode) / access to DB


 
Powered by phpBB® Forum Software