Multiple stores data as '|1|3|45|' because this is easy to parse
unambiguously using like '%|3|%'.

On Nov 16, 9:27 pm, Thadeus Burgess <thade...@thadeusb.com> wrote:
> What is special about the SQLFORM.widgets.checkboxes.widget that makes
> web2py process the data into a string of pipe separated integers?
> multiple=True
>
> It seems in my custom implementation of a checkboxes widget, will allow you
> to post multiple, however it stores the data as the actual list.
>
> I am trying to do a custom checkboxes that are displayed in a hierarchical
> tree. The checkboxes display correctly, but SQLFORM saves it wrong. Widget
> code in 0_plugin_categories.py
>
> Code:http://static.thadeusb.com/web2py.app.welcome.w2p
>
> Below, the first two are the SQLFORM widget, and the last three is testing
> with my custom widget.
>
> test.id <http://127.0.0.1:8000/welcome/appadmin/select/db?orderby=test.id>
> test.name<http://127.0.0.1:8000/welcome/appadmin/select/db?orderby=test.name>
> test.categories<http://127.0.0.1:8000/welcome/appadmin/select/db?orderby=test.categories>
> 1 <http://127.0.0.1:8000/welcome/appadmin/update/db/test/1>
> asdf|7|9|2<http://127.0.0.1:8000/welcome/appadmin/update/db/test/2>
> asdf2|6|11|12|5|3 <http://127.0.0.1:8000/welcome/appadmin/update/db/test/3>
> ['3', '4', '6']4 <http://127.0.0.1:8000/welcome/appadmin/update/db/test/4>
> ['2', '8', '12'] 5 <http://127.0.0.1:8000/welcome/appadmin/update/db/test/5>
> ['1', '2', '8...
>
> -Thadeus
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to