db.define_table("Questions",
Field('quesno', unique=True),
Field('question', 'text'),
Field('optionA', 'string'),
Field('optionB', 'string'),
Field('optionC', 'string'),
Field('optionD', 'string'),
Field('answer', 'string'),
Field('extra1','string'),
Field('extra2','string'))
db.define_table("secret",
Field('name','string'),
Field('quesstatus', 'integer',default=1),
Field('score', 'integer',default=0),
Field('score1', 'integer',default=0),
Field('Test', 'integer',default=1),
Field('correct', 'integer',default=0),
Field('wrong', 'integer',default=0),
Field('unanswered', 'integer',default=0),
Field('Level1Hint','integer'))
auth_count = db(db.auth_user.id >= 0).count()
secret_count = db(db.secret.id >= 0).count()
if(auth_count > secret_count):
db.secret.insert(name = auth.user.first_name)
db(db.secret.name == auth.user.first_name).update(quesstatus= 1)
db(db.secret.name == auth.user.first_name).update(score = 0)
db(db.secret.name == auth.user.first_name).update(Test = 1)
db(db.secret.name == auth.user.first_name).update(correct = 0)
db(db.secret.name == auth.user.first_name).update(wrong = 0)
db(db.secret.name == auth.user.first_name).update(unanswered = 0)
db(db.secret.name == auth.user.first_name).update(Level1Hint = 0)
elif(auth_count == secret_count):
db.secret(name = auth.user.first_name).update(quesstatus= 1)
db.secret(name = auth.user.first_name).update(score1 = 0)
db.secret(name = auth.user.first_name).update(Test = 1)
db.secret(name = auth.user.first_name).update(correct = 0)
db.secret(name = auth.user.first_name).update(wrong = 0)
db.secret(name = auth.user.first_name).update(unanswered = 0)
db.secret(name = auth.user.first_name).update(Level1Hint = 0)
Giving Error as
<type 'exceptions.AttributeError'> 'NoneType' object has no attribute
'first_name'
db(db.secret.name == auth.user.first_name).update(correct = 0)
db(db.secret.name == auth.user.first_name).update(wrong = 0)
db(db.secret.name == auth.user.first_name).update(unanswered = 0)
db(db.secret.name == auth.user.first_name).update(Level1Hint = 0)
elif(auth_count == secret_count):
db.secret(name = auth.user.first_name).update(quesstatus= 1)
db.secret(name = auth.user.first_name).update(score1 = 0)
db.secret(name = auth.user.first_name).update(Test = 1)
db.secret(name = auth.user.first_name).update(correct = 0)
db.secret(name = auth.user.first_name).update(wrong = 0)
Showing there is an error in color line. I am unable to find the error please
help me to solve to problem argent.
Regards,
T.SaiHarsh
--
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.
