Re: [web2py] DAL issues ....

2018-12-06 Thread Jim Steil
Thanks Ben On Thu, Dec 6, 2018 at 3:42 PM Ben Duncan wrote: > Controller Code: > > def company_login(): > > form = SQLFORM.factory( > Field('username', label = 'User Name', requires=IS_NOT_EMPTY()), > Field('password', 'password', label = > "Password",requires=IS_NOT_EMPTY())

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
Controller Code: def company_login(): form = SQLFORM.factory( Field('username', label = 'User Name', requires=IS_NOT_EMPTY()), Field('password', 'password', label = "Password",requires=IS_NOT_EMPTY()), Field('Company', label = 'Court ID', requires=IS_IN_DB(db,db.compa

Re: [web2py] DAL issues ....

2018-12-06 Thread Jim S
I'd love to see the final controller code if you have the time? Also, I'm curious as to why you're putting all this in the session. Why not just pass it in the dict being returned to the view? -Jim On Thursday, December 6, 2018 at 2:46:22 PM UTC-6, Ben Duncan wrote: > > Ok, YOU GUYS are awesom

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
Ok, YOU GUYS are awesome ... Your replies gave me the insight I needed ! Here is the explanation: A: in the database, the passes were for the "lookup" in the SQLFORM.factory SO there was the confusion there ... B: It seems there is a 2 passes thru the controller (which this group

Re: [web2py] DAL issues ....

2018-12-06 Thread Ben Duncan
The request.vars get set from the SQL form in the controller Removed all the COMMENTS, and in the controller put a print and changed the code: DbRows = db(db.company.company_number==Company_ID).select(db.company.company_name).first() print DbRows['company_name'] session.company_dat