tags:

views:

157

answers:

1
+1  Q: 

flex checkbox value not selected from database

Hi, I have a small flex datagrid. The dataProvider is an xmlList. I have two columns, userList and user permissions. The user permissions column as checkboxes. The values for the checkbox are stored as 0 and 1 in mySQL. While returning it from PHP, I am converting them to true or false. Its returning the values correctly to the frontend.

But inside the itemrenderer, the checkbox is not being set to true or false. Either everything is true or everything is false.

Here is my code. http://www.freeimagehosting.net/uploads/4ba76933d3.gif

How can I correctly set the value of the checkboxes from the DB values?

Please help.

+1  A: 

Change

<mx:CheckBox selected="{data.@selected}"/>

to

<mx:CheckBox selected="{Boolean(Number(data.@selected))}"/> (corrected thanx to Amarghosh)

and it should work fine.

Ladislav  2010-05-21 10:25:21
I'd use `selected="{Boolean(Number(data.@selected))}"` or `{data.@selected == "1"}` to be sure. The string `"0"` (like any other non empty string) evaluates to `true` in javascript (and most certainly in actionscript too).
Amarghosh  2010-05-21 10:36:24
I missed that he had 0, 1 as possibilities, my solution was if PHP returned true and false strings :)
Ladislav  2010-05-21 10:41:14
Hey thanks a lot Ladislav and Amar. selected="{Boolean(Number(data.@selected))}" worked.
Vish  2010-05-21 10:45:20
Again, the string `"false"`, like any other non empty string, evaluates to boolean `true`. Try this code and see it for yourself `if("false") alert("true"); else alert("false");`
Amarghosh  2010-05-21 10:47:39
Oh, damn, tested it with Boolean('true') and not with Boolean('false')...just goes to show you have to test every case :)Thanx
Ladislav  2010-05-21 11:03:15
Once the user sets some checkboxes, what is the best way to save these values back to the database? We use a WAMP server as backend.Thanks.
Vish  2010-05-21 11:12:59
Probably using XML or JSON and send the data to PHP which than updates the database...
Ladislav  2010-05-21 11:16:44
@Ladislav Edge cases.. they never stop coming! +1 :)
Amarghosh  2010-05-21 11:43:40

related questions

Silverlight vs Flex
Executing JavaScript from Flex: Is this javascript function dangerous?
How To Get Label Of Combobox to Fade In Flex
How do I change the title bar icon in Adobe AIR?
How do I call a Flex SWF from a remote domain using Flash (AS3) ?
Flex: does painless programmatic data binding exist?
SoapException: Root element is missing occurs when .NET web service called from Flex
Any recommendations for in-depth Flex training?
How do I restyle an Adobe Flex Accordion to include a button in each canvas header?
Deleting / Replacing A Node in E4X (AS3 - Flex)
How can I "unaccept" a drag in Flex?
Printing Flex components in FireFox 3
Is it possible to add behavior to a non-dynamic ActionScript 3 class without inheriting the class?
How do I get rid of the "multiple describeType entries" warning?
Open local file with AIR / Flex
Flex / Air obfuscation
Adobe Flex component events
Can you access the windows registry from Adobe Air?
Actionscript 3 - Fastest way to parse yyyy-mm-dd hh:mm:ss to a Date object?
Adobe Air - Using multiple SQLite databases at once
How can I unit test Flex applications from within the IDE or a build script?
Best way to learn Flash?
Get the current logged in OS user in Adobe Air
Adobe air - SQLStatement.execute() - Multiple queries in one statement
Unloading a ByteArray in Actionscript 3.