Leonel Câmara, Is that right?
db.executesql("execute procedure
esp_web_new_user('{0}','{1}','{2}','{3}','{4}',{5})".format(db._adapter.
dialect.quote(str(form.vars.f)),db._adapter.dialect.quote(str(form.vars.i)),
db._adapter.dialect.quote(str(form.vars.pser)),db._adapter.dialect.quote(str
(form.vars.pnum)),db._adapter.dialect.quote(str(form.vars.num)),db._adapter.
dialect.quote(auth.user_id))
)
*Marcelo Huerta*, yes I remember that site I think you take advice already
somebody to read that)
Now I have error all the same.
Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
Traceback (most recent call last):
File "Z:\OAS\web2py\gluon\restricted.py", line 219, in restricted
exec(ccode, environment)
File "Z:\OAS\web2py\applications\stud\controllers/default.py", line 1791, in
<module>
File "Z:\OAS\web2py\gluon\globals.py", line 421, in <lambda>
self._caller = lambda f: f()
File "Z:\OAS\web2py\gluon\tools.py", line 3868, in f
return action(*a, **b)
File "Z:\OAS\web2py\applications\stud\controllers/default.py", line 253, in
index
"execute procedure
esp_web_new_user('{0}','{1}','{2}','{3}','{4}',{5})".format(db._adapter.dialect.quote(str(form.vars.f)),db._adapter.dialect.quote(str(form.vars.i)),db._adapter.dialect.quote(str(form.vars.pser)),db._adapter.dialect.quote(str(form.vars.pnum)),db._adapter.dialect.quote(str(form.vars.num)),db._adapter.dialect.quote(auth.user_id))
File "Z:\OAS\web2py\gluon\packages\dal\pydal\base.py", line 772, in executesql
adapter.execute(query)
File "Z:\OAS\web2py\gluon\packages\dal\pydal\adapters\__init__.py", line 67,
in wrap
return f(*args, **kwargs)
File "Z:\OAS\web2py\gluon\packages\dal\pydal\adapters\base.py", line 413, in
execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
File "C:\Python27\lib\site-packages\fdb\fbcore.py", line 3627, in execute
self._ps._execute(parameters)
File "C:\Python27\lib\site-packages\fdb\fbcore.py", line 3333, in _execute
"Error while executing SQL statement:")
DatabaseError: ('Error while executing SQL statement:\n- SQLCODE: -802\n-
arithmetic exception, numeric overflow, or string truncation\n- string right
truncation', -802, 335544321)
Error snapshot [image: help]
<http://127.0.0.1:8000/admin/default/ticket/stud/127.0.0.1.2019-03-13.10-42-26.29fe283c-8997-4474-b4ba-9125a64b0991#>
<class 'fdb.fbcore.DatabaseError'>(('Error while executing SQL
statement:\n- SQLCODE: -802\n- arithmetic exception, numeric overflow, or
string truncation\n- string right truncation', -802, 335544321))
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
