or better
def index():
myform=SQLFORM(db.mytest,fields=['studentname'])
if myform.accepts(request.vars,session):
response.flash='record added'
myrecords=db().select(db.mytest.ALL)
if request.vars.multiple_update:
for r in myrecords:
if request.vars.has_key('id%i_grade1' % r.id):
r.update_record(gradeterm1=request.vars['id%i_grade1'
% r.id],
gradeterm2=request.vars['id
%i_grade2' % r.id])
myrecords=db().select(db.mytest.ALL)
return dict(form=myform, records=myrecords)
and
{{extend 'layout.html'}}
<h1>mytest entry form</h1>
{{=form}}
<h2>Current Records</h2>
<form>
<input type='hidden' name='multiple_update' value="true" />
<table>
<tr>
<td>Student Name</td>
<td>Grade - Term1</td>
<td>Grade - Term2</td>
</tr>
{{for record in records:}}
<tr>
<td>{{=A(record.studentname)}}</td>
<td><INPUT type="text", name="id{{=record.id}}_grade1", value=
{{=record.gradeterm1}} /></td>
<td><INPUT type="text", name="id{{=record.id}}_grade2", value=
{{=record.gradeterm2}} /></td>
</tr>
{{pass}}
</table>
<input type="submit" />
</form>
On Dec 20, 1:26 am, mdipierro <[email protected]> wrote:
> In your code.
>
> <td><INPUT type="text", name="grade1", value=
> {{=myrecords.gradeterm1}}></td>
> <td><INPUT type="text", name="grade2", value=
> {{=myrecords.gradeterm2}}></td>
>
> The two inputs are outside any form therefore nobody receives the
> input. This is an HTML issue, not a web2py issue. You can try:
>
> def index():
> myform=SQLFORM(db.mytest,fields=['studentname'])
> if myform.accepts(request.vars,session):
> response.flash='record added'
> myrecords=db().select(db.mytest.ALL)
> myforms=[SQLFORM(db.mytest,r) for r in myrecords,fields=
> ['gradeterm1','gradeterm2'])
> for f in myforms: f.accepts(request.vars,formname=str
> (f.records.id))
> return dict(form=myform, forms=myforms)
>
> and
>
> {{extend 'layout.html'}}
> <h1>mytest entry form</h1>
> {{=form}}
> <h2>Current Records</h2>
> <table>
> <tr>
> <td>Student Name</td>
> <td>Grade - Term1</td>
> <td>Grade - Term2</td>
> <td></td>
> </tr>
> {{for f in forms:}}
> <form>
> <tr>
> <td>{{=A(f.record.studentname)}}</td>
> <td><INPUT type="text", name="gradeterm1", value=
> {{=f.latest.gradeterm1}} /></td>
> <td><INPUT type="text", name="gradeterm2", value=
> {{=f.latest.gradeterm2}} /></td><td><input type="submit" /></td>
> </tr>
> {{=f.hidden_fields()}}
> </form>
> {{pass}}
> </table>
>
> On Dec 19, 4:13 pm, fja <[email protected]> wrote:
>
> > Thanks to everyone for their responses.
>
> > I am a VB and C# programmer for MS Windows Desktops, so I find myself
> > at a very steep learning curve here.
>
> > I have been using web2py for less than a day and am new to programming
> > with web frameworks. I like what I have seen so far with web2py and
> > would like to use the framework for future development.
>
> > The YUI components do look interesting, however I wouldn't know where
> > to begin using plugins at this stage.
>
> > I have included the very simple code I have done so far in hopes that
> > someone can point me in the right direction towards accomplishing
> > this. Articles and/or sample code would be greately appreciated.
>
> > Following the suggestion from Massimo, I have attempted a solution via
> > HTML, but I am not sure where to process the request.vars.
>
> > This is what I have so far....
>
> > MODEL - db.py
>
> > db.define_table('mytest', SQLField('studentname', 'string'), SQLField
> > ('gradeterm1','string'), SQLField('gradeterm2','string'))
>
> > CONTROLLER - mytest.py
>
> > def index():
> > myform=SQLFORM(db.mytest,fields=['studentname'])
> > if myform.accepts(request.vars,session):
> > response.flash='record added'
> > myrecords=db().select(db.mytest.ALL)
> > return dict(form=myform, records=myrecords)
>
> > VIEW - mytest/index.html
>
> > {{extend 'layout.html'}}
> > <h1>mytest entry form</h1>
> > {{=form}}
> > <h2>Current Records</h2>
> > <table>
> > <tr>
> > <td>Student Name</td>
> > <td>Grade - Term1</td>
> > <td>Grade - Term2</td>
> > </tr>
> > {{for myrecords in records:}}
> > <tr>
> > <td>{{=A(myrecords.studentname)}}</td>
> > <td><INPUT type="text", name="grade1", value=
> > {{=myrecords.gradeterm1}}></td>
> > <td><INPUT type="text", name="grade2", value=
> > {{=myrecords.gradeterm2}}></td>
> > </tr>
> > {{pass}}
> > </table>
> > <INPUT type="submit" value="Save"/>
>
> > This code gives me a nice form where I can add new students to the db,
> > and presents me with a list of all students in the db with input boxes
> > for the 2 term grades for each student.
>
> > When I press the Save button after filling in the grades, nothing
> > happens.
>
> > My questions are
>
> > 1. Upon pressing Save, who is receiving the data entered for the
> > grades?
> > 2. How can I associate the grade entered in the input boxes with the
> > student in the row, so I can call the update functions to update the
> > grades for each student respectively.
>
> > Thank you for help and patience.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
