Looks like you don't assign names to any of the selects, so their values are not passed via request.post_vars (and therefore don't make it into form.vars).
On Monday, March 4, 2013 11:54:23 AM UTC-5, Anthony Bond wrote: > > The values shouldn't be null - it should be a int value from between 0 and > 5. Even if the user didn't select any items, the default value will still > be 0 from the drop down list. > > On Monday, March 4, 2013 11:51:01 AM UTC-5, Anthony wrote: >> >> Did you previously define that column with notnull=True? If so, you may >> need to alter that column directly in MySQL so it allows null values. >> >> Anthony >> >> On Monday, March 4, 2013 11:41:05 AM UTC-5, Anthony Bond wrote: >>> >>> I've fixed the issue with the variable names by prefixing a letter to >>> the variable. However, the insert still does not function. Here's the >>> error: >>> >>> 127.0.0.1.2013-03-04.11-38-23.96eaf75d-0524-4eb8-8848-6000d1993dcd >>> <class 'gluon.contrib.pymysql.err.InternalError'> (1048, u"Column >>> 'Q4_3A' cannot be null") >>> >>> Traceback (most recent call last): >>> File "gluon/restricted.py", line 212, in restricted >>> File >>> "C:/Users/abond2/Desktop/web2py/web2py/web2py/applications/Teacher_Evaluation_System/controllers/evaluation.py" >>> >>> <http://127.0.0.1:8000/admin/default/edit/Teacher_Evaluation_System/controllers/evaluation.py>, >>> line 84, in <module> >>> File "gluon/globals.py", line 193, in <lambda> >>> File "gluon/tools.py", line 2929, in f >>> File >>> "C:/Users/abond2/Desktop/web2py/web2py/web2py/applications/Teacher_Evaluation_System/controllers/evaluation.py" >>> >>> <http://127.0.0.1:8000/admin/default/edit/Teacher_Evaluation_System/controllers/evaluation.py>, >>> line 28, in Take_Eval >>> File "gluon/dal.py", line 7918, in insert >>> File "gluon/dal.py", line 1176, in insert >>> InternalError: (1048, u"Column 'Q4_3A' cannot be null") >>> >>> >>> line 28, in Take_Eval refers to the insert method. Just a thought - do I >>> need to append something extra to "form.vars.Q4_3A" to get the value of >>> that particular drop down list? >>> >>> >>> On Sunday, March 3, 2013 2:34:29 PM UTC-5, Alan Etkin wrote: >>>> >>>> > My attempts at resolving this issue have made the implementation of >>>> the form much simpler, but I'm still unable to get the code to >>>> > compile after I put the insert in. I would appreciate and assistance >>>> you could provide in enlightening me as to why that insert >>>> > statement would not compile. >>>> >>>> Could you post the relevant part of the error ticket? >>>> >>>> -- --- 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.
