What happened when you tried this
solution: https://groups.google.com/d/msg/web2py/gDzXSbicFcI/BZKxpNs4GBIJ?
Also, note that in /controllername/actionname/2, the "2" is not a query
string -- it is just part of the URL path, and since it comes after the
action name, web2py interprets it as an arg and puts it in request.args. A
query string comes after a ? and consists of name=value pairs separated by
&'s -- web2py puts those variables and values into request.get_vars (and
also request.vars).
Anthony
On Thursday, May 16, 2013 9:45:20 AM UTC-4, Pawan Jha wrote:
>
> Hi
> Johann Spies
>
>
> as i am passing some value in url means passing value as query string
>
> like controllername/actionname/2
>
> i want to get all the value form table whose id = 2
>
> and want to display this value in Smartgrid
>
> but the present code is giving error . so please suggest me how will i use
> this .
>
>
>
> On Tue, May 14, 2013 at 7:27 PM, Anthony <abas...@gmail.com
> <javascript:>>wrote:
>
>> I'm not sure what you mean by that.
>>
>>
>> On Tuesday, May 14, 2013 8:56:55 AM UTC-4, Pawan Jha wrote:
>>
>>> its normal view page ..
>>>
>>>
>>> On Tue, May 14, 2013 at 6:25 PM, Anthony <abas...@gmail.com> wrote:
>>>
>>>> The first argument to smartgrid should be a table, not a query. If you
>>>> want to specify constraints, use the "constraints" argument, which is a
>>>> dictionary specifying constraint queries for each tablename:
>>>>
>>>> SQLFORM.smartgrid(db.call_log, constraints=dict(call_log=quer**y), ...)
>>>>
>>>> Anthony
>>>>
>>>>
>>>> On Tuesday, May 14, 2013 1:29:35 AM UTC-4, Pawan Jha wrote:
>>>>>
>>>>>
>>>>> Hi all Please let me know why this is giving error as i need to query
>>>>> the table as the value comes with the query string
>>>>>
>>>>>
>>>>> field = [db.call_log.call_datetime_**fro**m,db.call_log.incident_**
>>>>> street_**no,db.call_log.**incident_house_**no]
>>>>> page = request.args(0)
>>>>> query = db.call_log.incident_Id == page
>>>>> # == page
>>>>> #db.define_table('call_log',**Fi**eld('incident_Id'),auth.**signat
>>>>> **ure)
>>>>> query = db.call_log.incident_Id==page
>>>>> table= SQLFORM.smartgrid(query,
>>>>> user_signature=True,
>>>>> fields=field,
>>>>> deletable=False,
>>>>> editable=False,
>>>>> details=False,
>>>>> #selectable = lambda ids: clubCall(ids),
>>>>> #field_id=None,
>>>>> csv=False,
>>>>> paginate=20,
>>>>> #showbuttontext=False,
>>>>> searchable=False,
>>>>> #create=False,
>>>>> oncreate=None,
>>>>> onupdate=None,
>>>>> ondelete=None,
>>>>> )
>>>>> #formargs={},
>>>>> #createargs={},
>>>>> #editargs={},
>>>>> #viewargs={},
>>>>> #buttons_placement = 'right',
>>>>> #links_placement = 'right',
>>>>> #ignore_rw = False,)
>>>>> #query = (db.call_log.incident_Id >0).select()
>>>>>
>>>> --
>>>>
>>>> ---
>>>> 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+un...@**googlegroups.com.
>>>>
>>>> For more options, visit
>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>>> .
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> * Thanks & Regards
>>> Pawan Kr. Pankaj
>>> 91-9968831967/9540773888
>>> **Software Engineer (DOT .Net)*
>>> pawan.pan...@agnicient.com
>>>
>>>
>> --
>>
>> ---
>> 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+un...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> * Thanks & Regards
> Pawan Kr. Pankaj
> 91-9968831967/9540773888
> **Software Engineer (DOT .Net)*
> pawan.p <javascript:>an...@agnicient.com <javascript:>
>
>
--
---
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/groups/opt_out.
