Hi Massimo,
The printed values are " '9' 9L " in both cases.
Your first suggestion is ineffective,
but the second one solves this problem:
self.table._db(self.table.id==self.record.id).update(**fields)
I have another issue that seems to be mysql related, I'll post this
separately.
-Peter
On Feb 8, 5:22 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> I am puzzled. Can you help me debug this?
>
> Can you replace in sqlhtml.py
>
> self.table[record_id] = fields
>
> with
> print repr(record_id), repr(self.record.id)
> self.table[self.record.id] = fields
>
> and if it still does not work with
>
> print repr(record_id), repr(self.record.id)
> self.table._db
> (self.table.id==self.record.id).update(**fields)
>
> Let me know what happens.
>
> Massimo
>
> On Feb 8, 7:23 am, Peter <peter.kleyn...@gmail.com> wrote:
>
> > Until now I was running trunk r660 with MySQL with few problems. With
> > 1.56.1 a few new issues popped up. Code below works OK with 1.56.1 and
> > sqlite, but not with MySQL. Sessions are on the file system (default
> > settings), not in the DB.
>
> > If I submit the form without making any changes to it, I get a "no
> > such record" error from sql.py (see error msg below). If I DO make any
> > trivial change to field values in the form, it submits OK and is
> > stored in the database. If I pass t2.person_id to SQLFORM instead of
> > 'pers' , the result is the same.
>
> > Could this be some dependency on the old t2 module I still use?
> > Cheers,
> > -Peter
>
> > # default.py:
> > def testmysql():
> > pers = db(db.t2_person.id==t2.person_id).select()[0]
> > form = SQLFORM(db.t2_person,pers)
> > if form.accepts(request.vars,session):
> > redirect(URL(r=request,f='index'))
> > return dict(form=form)
>
> > # db.py:
> > db.define_table('t2_person',
> > SQLField('name',length=40,label='MoemID',requires=IS_NOT_EMPTY
> > (),unique=True),
> > SQLField('password','password',requires=CRYPT()),
> > SQLField('email',requires=IS_EMAIL()),
> > SQLField('registration_key',length=64),
> > SQLField('voornaam',default=''),
> > SQLField('achternaam',default='',length=50),
> > SQLField('adres',length=100,label='Straat en huisnr',default=''),
> > SQLField('postcode',length=10,default=''),
> > SQLField('plaats',length=50,default=''),
> > SQLField('land',requires=IS_IN_SET
> > ( COUNTRIES ),default='Nederland' ),
> > SQLField('telnr',length=20,label=T('06-nummer'),default=''),
> > SQLField('foto','upload',default=''),
> > SQLField('wiebenik','text',label='Over jou', default=''),
> > SQLField('created_by_ip',default='10.0.0.1'),
> > SQLField('created_on','datetime',default="1900-01-01 00:00:00"))
> > # validation business rules and widgets all disabled for this test
>
> > # error message:
> > Traceback (most recent call last):
> > File "/Library/Python/2.5/site-packages/web2py-1.56.1/gluon/
> > restricted.py", line 98, in restricted
> > exec ccode in environment
> > File "/Library/Python/2.5/site-packages/web2py-1.56.1/applications/
> > mijnmoem/controllers/default.py", line 296, in <module>
> > File "/Library/Python/2.5/site-packages/web2py-1.56.1/gluon/
> > globals.py", line 74, in <lambda>
> > self._caller = lambda f: f()
> > File "/Applications/web2py.app/Contents/Resources/applications/
> > mijnmoem/modules/t2.py", line 1039, in h
> > return f(*a,**b)
> > File "/Library/Python/2.5/site-packages/web2py-1.56.1/applications/
> > mijnmoem/controllers/default.py", line 79, in testmysql
> > if form.accepts(request.vars,session):
> > File "/Library/Python/2.5/site-packages/web2py-1.56.1/gluon/
> > sqlhtml.py", line 529, in accepts
> > self.table[record_id] = fields
> > File "/Library/Python/2.5/site-packages/web2py-1.56.1/gluon/sql.py",
> > line 982, in __setitem__
> > raise SyntaxError, 'No such record'
> > SyntaxError: No such record
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
