Hi,
Its me again, now when I put the code in the production(Linux box)
server i get this error, but in the computer i use to develop(Windows
xp) this don't happen.
Here i leave the error some idea?? PS: I double check the charset in
the database 10 time already :S
############# ERROR ##############################
Error traceback
Traceback (most recent call last):
File "H:\python\web2py_win\web2py_source\svn\gluon\restricted.py",
line 107, in restricted
File "/var/www/web2py/applications/dominos_times/controllers/
default.py", line 112, in <module>
File "H:\python\web2py_win\web2py_source\svn\gluon\globals.py", line
97, in <lambda>
File "H:\python\web2py_win\web2py_source\svn\gluon\tools.py", line
1207, in f
File "/var/www/web2py/applications/dominos_times/controllers/
default.py", line 98, in customcreate
form = crud.create('databasedp',onvalidation=lambda form:r(form),
onaccept=lambda form: f(form))
File "H:\python\web2py_win\web2py_source\svn\gluon\tools.py", line
1638, in create
File "H:\python\web2py_win\web2py_source\svn\gluon\tools.py", line
1596, in update
File "H:\python\web2py_win\web2py_source\svn\gluon\sqlhtml.py", line
580, in accepts
File "H:\python\web2py_win\web2py_source\svn\gluon\sql.py", line
1440, in insert
File "H:\python\web2py_win\web2py_source\svn\gluon\sql.py", line
717, in <lambda>
File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line
146, in execute
query = query.encode(charset)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position
299: ordinal not in range(128)
# # sample index page with internationalization (T)
response.menu =[['Login', False, URL(r=request, f='user/login')],
['Logout', False, URL(r=request, f='user/logout')]]
def index():
link_create=URL(r=request, f='customcreate')
link_search=URL(r=request, f='list_all')
return dict(link_create=link_create, link_search=link_search)
# # uncomment the following if you have defined "auth" and "crud" in
models
def user():
return dict(form=auth())
@auth.requires_login()
def data():
return dict(form=crud())
@auth.requires_login()
def list_all():
form=FORM(TABLE(TR('Select Store:', SELECT('All',
1,2,3,4,5,6,7,8,9,10,11,12,13,14, value='All', _name='store_id',
requires=IS_NOT_EMPTY())),
TR('Reason:', SELECT('All','Afp\xf6ntun', # HERE
i try to write the word with ÆÐÖÞ and them i change to hex some
result
'Anna\xf0',
'Ekki heimild',
'\xd3m\xf3ttekin',
'\xd3s\xf3tt',
'Remake',
'R\xf6ng b\xfa\xf0',
'Sein',
'S\xedmamist\xf6k',
'Staffamatur',
value='All', _name='reason', requires=IS_NOT_EMPTY())),
TR('Date', INPUT(_class="date", _id="date_field",
_type="date",_name="date", _value="All")),
("",INPUT(_type="submit",_value="Go"))))
query=""
db_store=db.databasedp.Store_id
db_reason=db.databasedp.reason
db_date=db.databasedp.date
st_store=request.vars.store_id
st_reason=request.vars.reason
st_date=request.vars.date
if st_date!="All":
q_date=db_date==st_date
else:
q_date=db_date==db_date
if st_store!="All":
q_store=db_store==st_store
else:
q_store=db_store==db_store
if st_reason!="All":
q_reason=db_reason==st_reason
else:
q_reason=db_reason==db_reason
if st_store=="All" and st_reason=="All" and st_date=="All": #Se
todos forem all
query=db().select(db.databasedp.ALL)
else:
query=db(q_store&q_date&q_reason).select()
return dict(form=form, query=query)
@auth.requires_login()
def customread():
id_order=request.args[0]
return dict(crudread=crud.read(db.databasedp, int(id_order)))
@auth.requires_login()
def customupdate():
id_order=request.args[0]
#if db.databasedp.id(id_order):
crud_output=crud.update(db.databasedp, int(id_order) ,next=URL
(r=request,args=request.args[0]))
return dict(crudupdate=crud_output)
@auth.requires_login()
def customcreate():
try:
if session.create:
pass
except:
session.create=[]
form = crud.create('databasedp',onvalidation=lambda form:r(form),
onaccept=lambda form: f(form))
return dict(form=form)
def f(form):
if session.create:
session.create.append(form.vars.id)
else:
session.create=[form.vars.id]
def r(form):
form.vars.total_payd=form.vars.total_amount-form.vars.total_credit
response._vars=response._caller(customcreate)
##########################################
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
