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 <[email protected]> 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 <[email protected]> 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)* >> [email protected] >> >> > -- > > --- > 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. > > > -- * Thanks & Regards Pawan Kr. Pankaj 91-9968831967/9540773888 **Software Engineer (DOT .Net)* pawan.p <[email protected]>[email protected]<[email protected]> -- --- 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.
