thanks massimo that work.
But that could be more simple if there are an opposit methode to
rows.as_list()
Is there any function in web2py like this rows = torows(mylistofdict)?
With a function like tihs we can easy past any data to a grid, smartgrid and
sqltable.
Le lundi 9 septembre 2013 02:56:24 UTC+2, Massimo Di Pierro a écrit :
>
> You can make is unique
>
> unique_key = response.session_id+'.temptable'
> db = cache.ram(unique_key,lambda:DAL('sqlite:memory'), None)
>
>
> On Sunday, 8 September 2013 09:40:53 UTC-5, keiser1080 wrote:
>>
>> thanks
>> this kinfd of table is unique for each session or user?
>>
>> Le dimanche 8 septembre 2013 04:03:40 UTC+2, Massimo Di Pierro a écrit :
>>>
>>> You can make a fate table in ram or in cache (DAL('sqlite:memory') or
>>> MEMDB),
>>>
>>> On Saturday, 7 September 2013 16:49:12 UTC-5, Anthony wrote:
>>>>
>>>> I think he wants the list of dictionaries to be the data displayed in
>>>> the table, not to be used to construct a query.
>>>>
>>>> On Saturday, September 7, 2013 2:34:01 PM UTC-4, Massimo Di Pierro
>>>> wrote:
>>>>>
>>>>> Something like this?
>>>>>
>>>>> def parse(table,d):
>>>>> return reduce(lambda a,b:a&b,[table[k]==v for k,v in d.iteritems()])
>>>>>
>>>>> SQLFORM.smartgrid(parse(db.yourtable, {'name':'alex', 'age':'55'}))
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Saturday, 7 September 2013 11:07:31 UTC-5, keiser1080 wrote:
>>>>>>
>>>>>> hi,
>>>>>>
>>>>>> It is possible tu use smartgrid with a list of dictionary in place of
>>>>>> a query?
>>>>>> Can i do something like this?
>>>>>>
>>>>>> smartgrid<http://www.web2py.com/examples/static/epydoc/gluon.sqlhtml.SQLFORM-class.html#smartgrid>
>>>>>> (table, constraints=None, linked_tables=None, links=None,
>>>>>> links_in_grid=True, args=None,user_signature=True, divider='>',
>>>>>> breadcrumbs_class='', **kwargs)
>>>>>>
>>>>>> smartgrid([{'name':'alex', 'age':'55'}, {'name':'albert', 'age':'44'
>>>>>> }])
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.