Sorry for the late response! i will test this ASAP
El viernes, 11 de septiembre de 2015, 13:48:56 (UTC-4:30), pjryan126
escribió:
>
> I haven't tested any of this -- I would need a little time to put
> something together, but I would attack the problem like this:
>
> 1. Create a Table object with appropriate fields and set migrate=False
> (This creates a dummy table)
> 2. Convert row values into a list of tuples
> 3. Use db._adapter.parse to create a DAL Rows object using the dummy table:
>
> t_rows = db._adapter.parse(rows, fields=[f for f in db.dummy_table],
> colnames=db.dummy_table.fields)
>
>
> 4. Create a SQLFORM.grid in controller and then replace the rows with your
> rows object using the DOM parser.
>
> grid = SQLFORM.grid(db.dummy_table)
> table = grid.element('.web2py_table')
> table[0] = t_rows
>
>
> On Thursday, September 10, 2015 at 6:50:49 PM UTC-4, Luis Valladares wrote:
>>
>> Well, that sounds like a big mess of db i/o, i think it will be better to
>> use javascript. Maybe this can be put in a "wish list" for future
>> development in web2py?
>>
>> Thanks for your help!
>>
>> El jueves, 10 de septiembre de 2015, 18:03:01 (UTC-4:30), Leonel Câmara
>> escribió:
>>>
>>> Well there is, but, it's not pretty. You could create a DAL instance
>>> using sqlite mem, then you put everything you get from the service there,
>>> then you send a query in that DAL instance to the grid.
>>>
>>> Frankly, this is not a good idea and you'll probably run into problems,
>>> you're better off using one of the many javascript grid options.
>>>
>>> Here are some options:
>>>
>>> http://handsontable.com/
>>> https://github.com/tonytomov/jqGrid/tree/master
>>> http://datatables.net/
>>>
>>> Or really just make it yourself it's really easy with stuff like
>>> ractivejs or similar.
>>>
>>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
