def index():
form=FORM(TABLE(TR("Last
Name:",INPUT(_type="text",_name="lname",requires=IS_LENGTH(minsize=3))),
TR("",INPUT(_type="submit",_value="SUBMIT"))))
message = " "
grid = None
fields = [db.Member.FIRST_NAME, db.Member.LAST_NAME]
default_sort_order=[db.Member.FIRST_NAME]
headers = {'Member.LAST_NAME_MIXED': 'ID' }
form2=FORM(TABLE(TR("Last
Name:",INPUT(_type="text",_name="conname",requires=IS_LENGTH(minsize=3))),
TR("",INPUT(_type="submit",_value="SUBMIT"))))
if form.process(session=None, formname='form',
keepvalues=True).accepted:
response.flash="form accepted"
rows3 = ((db.Member.LAST_NAME_MIXED.like(form.vars.lname + '%')))
jam=rows3
grid = SQLFORM.grid(rows3, fields=fields, headers=headers,
buttons_placement = 'left', links_placement = 'left')
elif form.errors:
response.flash="form is invalid"
else:
response.flash="Form incomplete"
table = request.args(0)
default_sort_order=[db.Member.FIRST_NAME]
if form2.process(session=None, formname='form2').accepted:
response.flash='form accepted'
rows = db((db.Employer.EMPLOYER_NAME.like(form2.vars.conname +
'%'))).select()
elif form2.errors:
response.flash='form is invalid'
else:
response.flash='form incomplete'
return dict(form=form, message=message, rows=rows, form2=form2,
grid=grid)
This is my current code if I enter a name into my form I get back the
correct table thats all dandy. But when I click "view" it loses the
"session" I would say because if I put my rows3 and grid outside of the if
statement and define something lets say rows3 =
((db.Member.LAST_NAME_MIXED.like('Fitz%'))) Im able to hit view and see
columns and there data. But I need the functionality of being able to
search but if its inside the if statement when i press View from the
SQLFORM.grid it doesnt keep the related field. I take the reasoning is
because inside the code prior to the return is grid= None. If you need
further explanation let me know that might sound confusing because im
becoming frustrated lol.
--
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
