Hello,
I have a SQLFORM.factory form that I need to prepopulate with some
data from a database.
id_nodo = request.args(0)
## I get the data from the database
nodo = db(db.node.id==id_nodo).select().first()
detalle = db(db.node_details.node_id==id_nodo).select().first()
##Now I need to prepolutate the fields title and body that I get from
the database
## title = nodo.title, body = detalle.body
form = SQLFORM.factory(db.node.title,db.node_details.body)
if form.accepts(request.vars,session):
response.flash='Form accepted'
return dict(form=form)
As I read on this thread
http://groups.google.es/group/web2py/browse_thread/thread/e2301b5cc3acd8dc/2a8ea5a2fba49bed?hl=es&lnk=gst&q=SQLForm+with+two+tables#2a8ea5a2fba49bed
somebody with the same problem as me did the following:
user = db((db.user.id == req_user_id) & (db.addr.user ==
req_user_id)).select()[0]
db.user.id.default = user.user.id
db.user.name.default = user.user.name
db.user.email.default = user.user.email
db.addr.city.default = user.addr.city
form =
SQLFORM.factory(db.user.name,db.user.rname,db.addr.city)
if form.accepts(request.vars, session):
# change the user data
if change_user_data(user):
user.user.update_record(name=form.vars.name) # <----
user.addr.update_record(city=form.vars.city) # <----
response.flash = 'form accepted'
else:
response.flash = 'form not accepted'
redirect(URL(r=request,f='index'))
I do not understand "if change_user_data(user):"
I have tried :
db.node.title.default = nodo.title
db.node_details.body = detalle.body
form = SQLFORM.factory(db.node.title,db.node_details.body)
if form.accepts(request.vars,session):
if change_node_data(node):
.......................................
......................................
but I get an execption ('global name change_node_data is not defined'.
Could anyone tell me how can I prepolutate the SQLFORM.factory form???
Why is the function change_user_data used in that example if is not
defined ????
Thanks in advance
--
Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
