Thanks Massimo
Solved the problem. The offending code is in the view - the code
calling show...
{{for entry in records:}}
<tbody><tr>
<td>{{=A(entry.title,_href=URL(r=request,f='show/%s'%entry.id))}}</td>
<td><br></td>
<td>{{=entry.datetime}}</td>
</tr>
{{pass}}
Thanks.
Maurice
On Feb 11, 8:05 am, Maurice Ling <mauricel...@gmail.com> wrote:
> Yes, if I changehttp://127.0.0.1:8000/cynote/cynote/show?id=1
> tohttp://127.0.0.1:8000/cynote/cynote/show/1
> It works.
>
> What do I have to change in the codes?
>
> Thanks
> ML
>
>
>
> >http://..../show?id=1
>
> > instead of
>
> >http://..../show/1
>
> > and that was the origin of the problem. When selft-submitting the form
> > in the page web2py thought this was an update form for record id=1,
> > which is not the case.
>
> > Massimo
>
> > On Feb 10, 9:13 am, Maurice Ling <mauricel...@gmail.com> wrote:
>
> > > I've changed to
>
> > > def show():
> > > # called to show one entry and its linked comments based on
> > > # the entry.id
> > > # called by TOC in order to provide an entry.id
> > > #id=request.vars.id
> > > id = request.args[0]
> > > ## <--- changed line
> > > entries=cynotedb(cynotedb.entry.id==id).select()
> > > # to prevent showing a 'None' (null) entry
> > > if not len(entries): redirect(URL(r=request,f='entries'))
> > > # form to post new comments
> > > comments=SQLFORM(cynotedb.comment,fields=['author','file','body'])
> > > # give entry.id for comment output
> > > comments.vars.entry_id = id;
> > > # return the comment that is listed with the entry id
> > > records=cynotedb(cynotedb.comment.entry_id==id)\
> > > .select(orderby=cynotedb.comment.entry_id)
> > > # show a flash when comment is posted
> > > if comments.accepts(request.vars,session):
> > > response.flash = "comment posted"
> > > return dict(entry=entries[0],comments=comments,records=records)
>
> > > It gives this error:
>
> > > Traceback (most recent call last):
> > > File "D:\web2py\gluon\restricted.py", line 98, in restricted
> > > exec ccode in environment
> > > File "D:/web2py/applications/cynote/controllers/cynote.py", line
> > > 131, in <module>
> > > File "D:\web2py\gluon\globals.py", line 74, in <lambda>
> > > self._caller = lambda f: f()
> > > File "D:/web2py/applications/cynote/controllers/cynote.py", line 22,
> > > in show
> > > id = request.args[0]
> > > IndexError: list index out of range
>
> > > And "print request.vars.id, request.args" shows "1 []" which is why
> > > there is an IndexError.
>
> > > ML
>
> > > On Feb 10, 10:37 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > Are you calling this create form with ?id=##
>
> > > > This confuses web2py. pass the id as args[0] and replace
>
> > > > id=request.vars.id
>
> > > > with
>
> > > > id=request.args[0]
>
> > > > Let me know if this is the problem.
>
> > > > On Feb 10, 8:24 am, Maurice Ling <mauricel...@gmail.com> wrote:
>
> > > > > To add, this problem does not seems to exist in Version 1.51
> > > > > (2008-11-19 14:48:02).
>
> > > > > Maurice Ling
>
> > > > > On Feb 10, 2:57 pm, Maurice Ling <mauricel...@gmail.com> wrote:
>
> > > > > > Hi Massimo
>
> > > > > > I have a problem here. One of my functions work perfectly in Version
> > > > > > 1.47 (2008-10-27 12:36:17) but failed in Version 1.56.2 (2009-02-08
> > > > > > 21:49:34) with this error
>
> > > > > > Traceback (most recent call last):
> > > > > > File "D:\web2py\gluon\restricted.py", line 98, in restricted
> > > > > > exec ccode in environment
> > > > > > File "D:/web2py/applications/cynote/controllers/cynote.py", line
> > > > > > 145, in <module>
> > > > > > File "D:\web2py\gluon\globals.py", line 74, in <lambda>
> > > > > > self._caller = lambda f: f()
> > > > > > File "D:/web2py/applications/cynote/controllers/cynote.py", line
> > > > > > 26,
> > > > > > in show
> > > > > > if comments.accepts(request.vars,session):
> > > > > > File "D:\web2py\gluon\sqlhtml.py", line 422, in accepts
> > > > > > raise SyntaxError, 'user is tampering with form'
> > > > > > SyntaxError: user is tampering with form
>
> > > > > > A snipplet of the model is this:
>
> > > > > > cynotedb.define_table('entry',
> > > > > > SQLField('title'),
> > > > > > SQLField('file','upload'),
> > > > > > SQLField('filename'),
> > > > > > SQLField('keywords',length=256),
> > > > > > SQLField('notebook',cynotedb.notebook),
> > > > > > SQLField('datetime','datetime',default=now),
> > > > > > SQLField('description','text'))
>
> > > > > > #the comment table
> > > > > > #entry_id link to entry table
> > > > > > cynotedb.define_table('comment',
> > > > > > SQLField('author'),
> > > > > > SQLField('file','upload'),
> > > > > > SQLField('filename'),
> > > > > > SQLField('body', 'text'),
> > > > > > SQLField('datetime','datetime',default=now),
> > > > > > SQLField('entry_id',cynotedb.entry))
>
> > > > > > The code in question is this:
>
> > > > > > def show():
> > > > > > # called to show one entry and its linked comments based on
> > > > > > # the entry.id
> > > > > > # called by TOC in order to provide an entry.id
> > > > > > id=request.vars.id
> > > > > > entries=cynotedb(cynotedb.entry.id==id).select()
> > > > > > # to prevent showing a 'None' (null) entry
> > > > > > if not len(entries): redirect(URL(r=request,f='entries'))
> > > > > > # form to post new comments
> > > > > > comments=SQLFORM(cynotedb.comment,fields=['author','body'])
> > > > > > # give entry.id for comment output
> > > > > > comments.vars.entry_id = id;
> > > > > > # return the comment that is listed with the entry id
> > > > > > records=cynotedb(cynotedb.comment.entry_id==id)\
> > > > > > .select(orderby=cynotedb.comment.entry_id)
> > > > > > # show a flash when comment is posted
> > > > > > if comments.accepts(request.vars,session):
> > > > > > response.flash = "comment posted"
> > > > > > return dict(entry=entries[0],comments=comments,records=records)
>
> > > > > > The error seems to lie at
> > > > > > if comments.accepts(request.vars,session):
> > > > > > response.flash = "comment posted"
>
> > > > > > When I comment out these Version 1.56.2 (2009-02-08 21:49:34), the
> > > > > > function works but I am not able to add new comments into
> > > > > > cynotedb.comment table.
>
> > > > > > I think this error seems to be induced by a new version of web2py.
> > > > > > My reasons being:
>
> > > > > > 1. When I run a older developmental version of my application
> > > > > > (cynote)
> > > > > > in Version 1.47, it works nicely - Not in Version 1.56.2
>
> > > > > > 2. When I copy and pasted the older version into my application in
> > > > > > web2py Version 1.56.2 (trying to rule out indentation and invisible
> > > > > > characters error), it failed.
>
> > > > > > 3. When I copied the entire application directory into web2py
> > > > > > Version
> > > > > > 1.47, it works fine.
>
> > > > > > Hence, the only reason that I cannot rule out is the difference in
> > > > > > web2py versions.
>
> > > > > > Please advice.
>
> > > > > > Thanks
> > > > > > Maurice Ling
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
