I'm new to web2py, but do have a php and mysql background using codeigniter. I'm trying to write a couple of queries but sure how to do them. These are the queries I'm trying to write,
query1 SELECT user.s_name, user.f_name, user.year, pe.date, pe.sport, pe.id FROM user INNER JOIN pe ON user.user_id=pe.user_id WHERE pe.date = DATE(NOW()) ORDER BY user.year" query 2 SELECT user.upn, user.f_name, user.s_name where user.upn = '4444' I tried this on the second query, thelist=[row.first_name for row in db().select(db.pupils.first_name, db.pupils.upn')] which pulls all records, need to know where to put " where upn = '4444'" Thanks in advance. -- 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/d/optout.
