CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 CCS5 - Editable grid + checkbox doesn't work? [RESOLVED]

Print topic Send  topic

Author Message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
saseow

Posts: 727
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.
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
MichaelMcDonald

Posts: 638
Posted: 12/12/2015, 6:43 PM

putting WTF in the global db dictionary :-P
_________________
Central Coast, NSW, Australia.

View profile  Send private message
Gena

Posts: 591
Posted: 12/13/2015, 2:16 AM

Quote MichaelMcDonald:
putting WTF in the global db dictionary :-P
LOL!! <g>

_________________
Gena
View profile  Send private message
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
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.