Dear Massimo,
First of all I want to thank you for such quick response.
Herewith my partial code of my model:
#kindofcontact
db.define_table('kindofcontact',
SQLField('catname','string', length=64, required=True),
SQLField('description','text'),
SQLField('createdon','datetime', default=now))
db.kindofcontact.catname.requires=[IS_NOT_EMPTY(), IS_NOT_IN_DB
(db,'kindofcontact.catname')]
db.kindofcontact.createdon.requires=IS_DATETIME()
#Person
db.define_table('person',
SQLField('catname', db.kindofcontact, required=True),
SQLField
('lastname','string',length=32,default='',required=True,ondelete='CASCADE'),
SQLField('firstname', 'string',length=32,default=''),
SQLField('callingname','string',length=32,default=''),
SQLField('middlename','string',length=10),
SQLField('initials','string',length=32),
SQLField('createdon','datetime', default=now))
db.person.catname.requires=[IS_NOT_EMPTY(), IS_IN_DB
(db,'kindofcontact.id','%(catname)s')]
db.person.lastname.requires=[IS_NOT_EMPTY()]
db.person.initials.requires=[IS_NOT_EMPTY()]
db.person.createdon.requires=IS_DATETIME()
#person address
db.define_table('address',
SQLField('person_id',db.person,required=True),
# SQLField('category','string',length=32),
SQLField('street','string',length=32,default=''),
SQLField('state','string',length=2,default=''),
SQLField('Postalcode','string',length=10,default=''),
SQLField('country','string',length=16, default=''),
SQLField('createdon','datetime', default=now))
As far as I see, I follow the thought/rule. I thouth that a possible
wrong drive could be the course. But I have checked my installation
and I have installed pscopg2 version 2.07.
Further what I discovered was that the following wil work. (which
should)
db.person.catname.requires=[IS_NOT_EMPTY(), IS_IN_DB
(db,'kindofcontact.id','id' )]
Thanks in advance.
Matt van Gerwen
On Dec 22, 2:09 pm, mdipierro <[email protected]> wrote:
> Hi Matt, two issues
>
> 1)
> db.person.catname.requires=[IS_NOT_EMPTY(), IS_IN_DB
> (db,'kindofcontact.id','%(catname)s')]
>
> should be if you want a dropbox.
>
> db.person.catname.requires=IS_IN_DB(db,'kindofcontact.id','%
> (catname)s')
>
> 2) the error you are getting is very strange. Your database seems to
> return 'ANZN' for a field that is supposed to be integer.
> Are you sure person.catname is a referece to kindofcontact.id?
>
> If not and you are actually trying to store the kindofcontact.catname
> in person.catname than this should be
>
> db.person.catname.requires=IS_IN_DB(db,'kindofcontact.catname')
>
> Massimo
>
> On Dec 22, 6:30 am, mattvangerwen <[email protected]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
