Hi,
I'm new to web2py. Even though I like to have postgresl as database.
For a crm application and later on for an casemanager application, I
like to several category-tables. For example a person can have
multiple phone-numbers for different companies. In SQLite it is
possible to select a value by name instead by id-number. However this
does not work with a Postgresql database, with the following statement
I get an error
db.person.catname.requires=[IS_NOT_EMPTY(), IS_IN_DB
(db,'kindofcontact.id','%(catname)s')]
The error is:
What should I do to solve this?
Traceback (most recent call last):
File "/idata/development/web2py/gluon/restricted.py", line 62, in
restricted
exec ccode in environment
File "/idata/development/web2py/applications/webCRM/controllers/
appadmin.py", line 196, in <module>
File "/idata/development/web2py/gluon/globals.py", line 55, in
<lambda>
self._caller=lambda f: f()
File "/idata/development/web2py/applications/webCRM/controllers/
appadmin.py", line 53, in insert
if form.accepts(request.vars,session):
File "/idata/development/web2py/gluon/sqlhtml.py", line 172, in
accepts
ret=FORM.accepts(self,vars,session,formname,keepvalues)
File "/idata/development/web2py/gluon/html.py", line 490, in accepts
status=self._traverse(status)
File "/idata/development/web2py/gluon/html.py", line 136, in
_traverse
newstatus=c._traverse(status) and newstatus
File "/idata/development/web2py/gluon/html.py", line 136, in
_traverse
newstatus=c._traverse(status) and newstatus
File "/idata/development/web2py/gluon/html.py", line 136, in
_traverse
newstatus=c._traverse(status) and newstatus
File "/idata/development/web2py/gluon/html.py", line 136, in
_traverse
newstatus=c._traverse(status) and newstatus
File "/idata/development/web2py/gluon/html.py", line 139, in
_traverse
newstatus=self._validate()
File "/idata/development/web2py/gluon/html.py", line 366, in
_validate
value,errors=validator(value)
File "/idata/development/web2py/gluon/validators.py", line 160, in
__call__
if len(self.dbset(field==value).select(limitby=(0,1))):
File "/idata/development/web2py/gluon/sql.py", line 922, in __eq__
def __eq__(self,value): return SQLQuery(self,'=',value)
File "/idata/development/web2py/gluon/sql.py", line 1065, in
__init__
right=sql_represent(right,left.type,left._db._dbname)
File "/idata/development/web2py/gluon/sql.py", line 261, in
sql_represent
if fieldtype[0]=='i': return str(int(obj))
ValueError: invalid literal for int() with base 10: 'ANZN'
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
