Thanks Richard, works correctly now. What does this mean? "About you predefined choice from a all ready existing record (update mode with .factory()), I you have to set the default value for the form base on the value extract form the DB for the existing record"
Do you mean I should copy this line to inside the IF FORM ACCEPTED indent? "db.IdeaComment.ideaID.default = request.vars.filter" thanks, Alex On Friday, September 13, 2013 7:41:05 AM UTC-7, Richard wrote: > > Hi Alex, > > I didn't read carefully your code but just a couple advice... With > SQLFORM.factory you need to insert you data yourself like this : > > form = SQLFORM.factory(db.your_table_name, ...) > if form.process().accept: > id = > db.lotns_sample.insert(**db.your_table_name._filter_fields(form.vars)) > > You can re-use the id of inserted record when you use more than one table > in your SQLFORM.factory(db.table1, db.table2)... > > This is covert in the book. > > About you predefined choice from a all ready existing record (update mode > with .factory()), I you have to set the default value for the form base on > the value extract form the DB for the existing record... > > Hope it helps. > > Richard > > > On Thu, Sep 12, 2013 at 8:03 PM, Alex Glaros <[email protected]<javascript:> > > wrote: > >> Anybody see anything wrong with the second controller below that gets >> called by the first one? >> >> The error is that no data gets written to table IdeaComment, but if I >> substitute "smartgrid" for "factory", all suggestions instead of just the >> one selected in the first controller get displayed, and forces me to >> re-choose a suggestion, then it writes it correctly. >> >> No errors displayed when "factory" is used in second controller, but no >> record is written. >> >> Controller >> >> @auth.requires_login() >> def add_suggestion_comments(): ## This controller selects a suggestion >> record (db.Idea) and passes selection to controller comment_on_a_suggestion >> below. >> db.Suggestion.ideaID.represent = lambda id, r: >> A(db.Idea(id).ideaTitle, _href=URL('comment_on_a_suggestion', >> vars=dict(filter=id))) >> query = ((db.Suggestion.ideaID == db.Idea.id)) >> suggestionList = >> SQLFORM.grid(query,create=True,editable=True,deletable=True, >> details=True,links_in_grid=True, paginate=10, >> fields=[db.Suggestion.ideaID, db.Idea.ideaShortSummary], >> maxtextlength={db.Idea.ideaShortSummary:140}) >> return dict(suggestionList = suggestionList) >> >> @auth.requires_login() ## This controller receives Idea.id parm from >> add_suggestion_comments controller above. It then writes user comments to >> table db.IdeaComment >> def comment_on_a_suggestion(): >> db.IdeaComment.ideaID.readable = True >> db.IdeaComment.ideaID.writable = False >> db.auth_user.partyID.readable = db.auth_user.partyID.writable = False >> >> db.IdeaComment.ideaID.default = request.vars.filter >> db.IdeaComment.ideaStageID.default = 1 ## make default 'Suggestion' >> >> db.IdeaComment.ideaStageID.readable = >> db.IdeaComment.ideaStageID.writable = False >> form=SQLFORM.factory(db.IdeaComment) >> if form.process().accepted: >> response.flash='Thanks for adding a comment to a suggestion.' >> return dict(form=form) >> >> >> Model >> >> db.define_table('IdeaComment', ## lets any registered user make a >> commment on suggestion >> Field('ideaID','reference Idea'), >> Field('partyID','reference Party', label='Commenter', comment='Party that >> is commenting'), ## this is commenter. Has to be logged on. >> Field('ideaStageID','reference IdeaStageLookupTable', comment='What stage >> of the idea do you want to comment on? Suggestion, proposal, effort, >> project, program?'), >> Field('ideaComment','string', label='Comment', comment='Your comments'), >> Field('personClassCode','reference PersonClass', comment='In what >> capacity are you making this comment?')) >> >> ## --------------------------------------------------- >> db.define_table('Idea', >> Field('ideaTitle','string', length=140, label='Idea Title', comment='140 >> characters max'), >> Field('ideaShortSummary','string', length=280, label='Summary info', >> comment='short summary - 280 characters max'), >> Field('ideaStageID','reference IdeaStageLookupTable', label='Idea Stage', >> comment='Idea stage may be part of a series of stages of an idea: >> Suggestion, Proposal, Effort, Project, and Program. (1) Suggestion - The >> first time an idea is presented; the original concept (2) Proposal - a >> specific plan to fully implement and idea by a specific party (3) Effort - >> the work done on a proposal such as evaluation before the effort is >> transformed into a project. It may never transform into a project, in >> which case it can be categorized as a task or series of tasks (4) Project - >> sequence of tasks, planned from beginning to end, bounded by time, i.e., >> has start and end date, resources, and required results, defined outcome >> and "deliverables" (5) Program - a permanent or long-term re-occurring >> event, such as the "Head-Start Program" or a warehouse inventory system.')) >> >> ## --------------------------------------------------- >> db.define_table('Suggestion', >> Field('ideaID', 'reference Idea',label='Suggestion Idea ID'), ## not sure >> if this should not be objectID: Field('objectID', 'reference >> ObjectSuperType'), >> Field('objectID', 'reference ObjectSuperType'), ## harmless redundancy, >> but keeps my options open >> Field('IPcreatedBy','string'), >> Field('partyID','reference Party', label='Party making the suggestion'), >> ## need to make this limited to what person's party capacities are >> Field('personClassCode','string')) >> >> thanks, >> >> Alex Glaros >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- 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/groups/opt_out.
