Hi,
Just getting into web2py, but I've been having this issue.
Why does the following query:
query = db.bids.job_id == job_id and db.bids.confirmed=='No' and
db.bids.delivered=='No'
on this table structure:
db.define_table('bids',
Field('body', 'text', label="Application"),
Field('selected', 'string', requires=IS_IN_SET(['Yes',
'No']), readable=False, writable=False, default='No',
widget=SQLFORM.widgets.radio.widget, label="Select this application"),
Field('confirmed', 'string', requires=IS_IN_SET(['Yes',
'No']), readable=False, writable=False, default='No',
widget=SQLFORM.widgets.radio.widget, label="Confirm acceptance"),
Field('delivered', 'string', requires=IS_IN_SET(['Yes',
'No']), readable=False, writable=False, default='No'),
Field('posted_on', 'datetime', readable=True,
writable=False),
Field('posted_by', 'reference auth_user', readable=False,
writable=False),
Field('job_id', 'reference jobs', readable=False,
writable=False)
)
give this error:
<type 'exceptions.KeyError'>
For reference the job table definition is:
db.define_table('jobs',
Field('job', 'string', requires=[IS_LENGTH(50,1),
IS_NOT_EMPTY()]),
Field('posted_on', 'datetime', readable=True,
writable=False),
Field('posted_by', 'reference auth_user', readable=False,
writable=False, default='auth_user.id'),
format='%(Job)s')
I'm expecting the equivalent of this be performed on the table:
SELECT
<http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/select.html>
* FROM `bids` where job_id = 2 and
<http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and>
confirmed = 'No' and
<http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and>
delivered = 'No'
--
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.
