looks like a good fix. thanks. it is in trunk.
On Sep 25, 11:42 am, Napoleon Moreno <[email protected]> wrote: > Good day sir > > It works for me if i change in web2py/gluon/contrib/gql.py > > L617 > > def __str__(self): > return ' AND '.join([str(filter) for filter in self.filters]) > > for > > def __str__(self): > return ' AND '.join([unicode(filter) for filter in self.filters]) > > Maybe that is not the right solution, but it could help to fix it > > On Sat, Sep 25, 2010 at 10:55 AM, Napoleon Moreno <[email protected]>wrote: > > > I tried it > > > It works well in sqllite > > > In gae returns a ticket: > > > Traceback (most recent call last): > > File "/home/napoleon/triviaapp/web2py/gluon/restricted.py", line 188, in > > restricted > > exec ccode in environment > > File > > "/home/napoleon/triviaapp/web2py/applications/welcome/controllers/default.py:category", > > line 266, in <module> > > File "/home/napoleon/triviaapp/web2py/gluon/globals.py", line 96, in > > <lambda> > > self._caller = lambda f: f() > > File > > "/home/napoleon/triviaapp/web2py/applications/welcome/controllers/default.py:category", > > line 57, in category > > File "/home/napoleon/triviaapp/web2py/gluon/tools.py", line 2837, in > > create > > deletable=False, > > File "/home/napoleon/triviaapp/web2py/gluon/tools.py", line 2780, in > > update > > hideerror=self.settings.hideerror): > > File "/home/napoleon/triviaapp/web2py/gluon/sqlhtml.py", line 952, in > > accepts > > hideerror=hideerror, > > File "/home/napoleon/triviaapp/web2py/gluon/html.py", line 1542, in > > accepts > > status = self._traverse(status,hideerror) > > File "/home/napoleon/triviaapp/web2py/gluon/html.py", line 552, in > > _traverse > > newstatus = c._traverse(status,hideerror) and newstatus > > File "/home/napoleon/triviaapp/web2py/gluon/html.py", line 552, in > > _traverse > > newstatus = c._traverse(status,hideerror) and newstatus > > File "/home/napoleon/triviaapp/web2py/gluon/html.py", line 552, in > > _traverse > > newstatus = c._traverse(status,hideerror) and newstatus > > File "/home/napoleon/triviaapp/web2py/gluon/html.py", line 552, in > > _traverse > > newstatus = c._traverse(status,hideerror) and newstatus > > File "/home/napoleon/triviaapp/web2py/gluon/html.py", line 559, in > > _traverse > > newstatus = self._validate() > > File "/home/napoleon/triviaapp/web2py/gluon/html.py", line 1330, in > > _validate > > (value, errors) = validator(value) > > File "/home/napoleon/triviaapp/web2py/gluon/validators.py", line 493, in > > __call__ > > rows = self.dbset(field == value).select(limitby=(0, 1)) > > File "/home/napoleon/triviaapp/web2py/gluon/contrib/gql.py", line 737, in > > select > > self._db['_lastsql'] = 'SELECT WHERE %s' % self.where > > File "/home/napoleon/triviaapp/web2py/gluon/contrib/gql.py", line 615, in > > __str__ > > > return ' AND '.join([str(filter) for filter in self.filters]) > > UnicodeEncodeError: 'ascii' codec can't encode characters in position 7-10: > > ordinal not in range(128) > > > INFO 2010-09-25 15:47:49,038 gaehandler.py:65] **** Request: > > 49.73ms/50.00ms (real time/cpu time) > > INFO 2010-09-25 15:47:49,043 recording.py:327] Saved; key: > > __appstats__:068900, part: 121 bytes, full: 15295 bytes, overhead: 0.001 + > > 0.006; link:http://localhost:8080/stats/details?time=1285429668988 > > INFO 2010-09-25 15:47:49,049 dev_appserver.py:3275] "POST > > /welcome/default/category HTTP/1.1" 500 - > > INFO 2010-09-25 15:47:49,097 gaehandler.py:65] **** Request: > > 0.60ms/0.00ms (real time/cpu time) > > INFO 2010-09-25 15:47:49,098 recording.py:327] Saved; key: > > __appstats__:069000, part: 31 bytes, full: 1052 bytes, overhead: 0.000 + > > 0.001; link:http://localhost:8080/stats/details?time=1285429669097 > > INFO 2010-09-25 15:47:49,105 dev_appserver.py:3275] "GET /favicon.ico > > HTTP/1.1" 400 - > > > On Sat, Sep 25, 2010 at 10:16 AM, mdipierro <[email protected]>wrote: > > >> can you help us debug? Try > > >> db.category.name.requires = IS_NOT_IN_DB(db, 'category.name') > > >> On Sep 25, 8:37 am, Napoleon Moreno <[email protected]> wrote: > >> > Good day > > >> > My dal was: > > >> > db.define_table('category', > >> > Field('name','string'), > >> > format='%(name)s' > >> > ) > > >> > db.category.name.requires = IS_NOT_IN_DB(db, db.category.name) > > >> > The error ocurrs in db.category.name.requires = IS_NOT_IN_DB(db, > >> > db.category.name). > > >> > I removed this for the moment. > > >> > Thanks for any advice. > > >> > On Thu, Sep 23, 2010 at 9:38 PM, Napoleon Moreno <[email protected] > >> >wrote: > > >> > > Good night > > >> > > i have a simple form to input data in hebrew > > >> > > I works ok in in sqlLite. > > >> > > in GAE it returns: > > >> > > return ' AND '.join([str(filter) for filter in self.filters]) > >> > > UnicodeEncodeError: 'ascii' codec can't encode characters in position > >> 7-11: > >> > > ordinal not in range(128) > > >> > > db.define_table('category', > >> > > Field('name','string'), > >> > > format='%(name)s' > >> > > ) > > >> > > this is the form: > > >> > > form = crud.create(db.category, next=URL('category'), > >> > > message=T("record created")) > >> > > categories = crud.select(db.category, fields=['name'], > >> > > headers={'category.name': 'Name'}) > >> > > return dict(form=form, categories=categories) > >
