I thought I had escaped/ solved this error. But now am stuck. My db.py code:
Post = db.define_table('post',
Field('message', 'text', requires=IS_NOT_EMPTY(),
notnull=False),
Field('answers', 'text', requires=IS_NOT_EMPTY(),
notnull=False),
auth.signature
)Post.is_active.readable=FalsePost.is_active.writeable=False
controller:
@auth.requires_login()
def index():
db.post.answers.writable=False
db.post.answers.readable=False
form = SQLFORM(post, formstyle='divs')
if form.process().accepted:
pass
messages = db(post).select(orderby=~post.created_on)
.......code
#after several codes in now need to post a message to answers field,
WITHOUT using a form in the view page
db.post.insert(answers=report)
In my view:
{{for msg in messages:}}
code{{=msg.message}}{{report from answers field}}
My issue is that i keep getting the error: IntegrityError('NOT NULL
constraint failed:post.message.
The two fields get data from different sources, post.message, from form in
view and post.answers from a function in the code.
How do I solve this error? Kind regards
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
