Hi,
I have this:
tags=db().select(db.event_tags.ALL)
form
=SQLFORM(db.events,fields=['title','venue','starttime','endtime','location','image','cost','website','booking','latlng','information'])
#form = SQLFORM(db.events)
my_extra_element = TR("",INPUT(_id='Lookup',_value="Check
Map",_type='submit'))
form[0].insert(5,my_extra_element)
my_extra_element = TR("Add
Tags",SELECT(_name='tags',_multiple='multiple',*[OPTION(tags[i].name,_value=str(tags[i].id))
for i in range(len(tags))]))
form[0].insert(-1,my_extra_element)
if form.accepts(request.vars, session,keepvalues=True):
db.events.insert(**db.events._filter_fields(form.vars))
cache.ram.clear()
response.flash = 'form accepted'
redirect(URL('index'))
print "form accepted"
elif form.errors:
response.flash = 'form has errors'
print "form has errors"
else:
response.flash = 'please fill out the form'
print "fill out form"
return dict(form=form)
this is part of the database model is this:
Field('image', 'upload',label=T('Profile Image')),
Field('userid',db.auth_user,default = auth.user and auth.user.id),
Field('tags','list:reference event_tags')
Whenever I submit the form, 2 records get added. I'm not sure as to
why this is happening.
Could anyone shed some light on this problem ?
Nils
