Gena
Posts: 591
|
Posted: 12/09/2015, 2:15 PM |
|
CCS5 + php + mysql
I have strange situation.
I have simple standard Editable grid with checkbox inside.
Checkbox shows correct state (from database field) BUT if i want to change it (click on Checkbox and it set 1 (CHECKED) value or uncheck it) and then press Update button all other fields from the grid will be updated correctly but not checkbox field!!! It always set 0 value (I have echoed UPDATE statement).
I have tried different way - no way to go! It doesn't work as expected!!!
the same thing works well in CCS3 !!!
Any ideas please??
even standard Delete checkbox doesn't work at all!!
_________________
Gena |
|
|
eratech
Posts: 513
|
Posted: 12/10/2015, 10:13 PM |
|
Hi Gena - just wondering what the data type of the checkbox field is in the database (sometimes if not matching the DB might change it to default of 0/false. I get that with ENUMs fields if you pass something not in the ENUM list)
Also, are you using the built-in update or is it a Custom Update code? If so, have you checked the field is actually being updated in Custom Update?
Cheers
Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
Gena
Posts: 591
|
Posted: 12/11/2015, 4:27 PM |
|
Eric,
checkbox is defined as integer in database.
and I am using the built-in update - all just standard...
Can you try to create (using builder) simple Editable grid with checkbox and then check it it works?
_________________
Gena |
|
|
saseow
Posts: 744
|
Posted: 12/11/2015, 8:37 PM |
|
Gena, it definitely works perfectly. I have done this numerous times without a hitch.
Perhaps you should just recreate the grid.
|
|
|
Gena
Posts: 591
|
Posted: 12/12/2015, 2:12 AM |
|
Quote saseow:
Gena, it definitely works perfectly. I have done this numerous times without a hitch.
Perhaps you should just recreate the grid.
That's gets me crazy! I know it should works!
Probably there is a reason, but I don't know how to fix it.
My grid is locatetd in includable page that is part of the page that is part of Design... It looks like a JS misleading in the whole generated code...
_________________
Gena |
|
|
Gena
Posts: 591
|
Posted: 12/12/2015, 7:12 AM |
|
WTF!!!!
I found the problem!!!
I am using Artisteer Design, so I defined a style for checkbox. Then runtime all my checkboxes becames label with images!!!! And you work just with this images and not with your real checkbox controls!!!!!
After I changed to use Standard checkbox control all works fine as expected!!!
WTF!!!
_________________
Gena |
|
|
eratech
Posts: 513
|
Posted: 12/12/2015, 4:04 PM |
|
Gena - thanks for letting us know the solution. I haven't had that happen but will keep an eye out for it in future.
So I guess if you wanted to keep the styled checkboxes, you would need to write JS toggle code to change the underlying checkbox when you click the image on top?
Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
MichaelMcDonald
Posts: 640
|
Posted: 12/12/2015, 6:43 PM |
|
putting WTF in the global db dictionary
_________________
Central Coast, NSW, Australia.
|
|
|
Gena
Posts: 591
|
Posted: 12/13/2015, 2:16 AM |
|
Quote MichaelMcDonald:
putting WTF in the global db dictionary
LOL!! <g>
_________________
Gena |
|
|
Gena
Posts: 591
|
Posted: 12/13/2015, 2:25 AM |
|
Quote eratech:
So I guess if you wanted to keep the styled checkboxes, you would need to write JS toggle code to change the underlying checkbox when you click the image on top?
Eric,
What JS toggle code do you mean? CCS or Artisteer Design? Yes, there is a script.js in Artisteer Design that should handle this but it seems has a bugs... I am not expert in JS so can't say anything about how to fox it correctly...
CCS js code is good the problem is that you just don't work with checkboxes itself but with images that does'n toggle real checkbox control correctly.
_________________
Gena |
|
|