what database are you using? did you ever change the field type?
On Tuesday, 7 July 2015 16:40:39 UTC-5, kulin shah wrote:
>
> Hi,
> I am a newbie to web2py and programming in general. I have something like
> this:
> Field('cc_list','list:integer',requires=IS_EMPTY_OR(IS_IN_DB(db,'
> auth_user.id',db.auth_user._format,multiple=True))),
> but this is giving an error:
> 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 "/home/kulin/web2py/gluon/restricted.py", line 227, in restricted
> exec ccode in environment
> File "/home/kulin/web2py/applications/tester/controllers/default.py"
> <http://127.0.0.1:8000/admin/default/edit/tester/controllers/default.py>,
> line 143, in <module>
> File "/home/kulin/web2py/gluon/globals.py", line 412, in <lambda>
> self._caller = lambda f: f()
> File "/home/kulin/web2py/gluon/tools.py", line 3583, in f
> return action(*a, **b)
> File "/home/kulin/web2py/applications/tester/controllers/default.py"
> <http://127.0.0.1:8000/admin/default/edit/tester/controllers/default.py>,
> line 50, in create_details
> form = SQLFORM(db.post).process()
> File "/home/kulin/web2py/gluon/html.py", line 2301, in process
> self.validate(**kwargs)
> File "/home/kulin/web2py/gluon/html.py", line 2238, in validate
> if self.accepts(**kwargs):
> File "/home/kulin/web2py/gluon/sqlhtml.py", line 1688, in accepts
> self.vars.id = self.table.insert(**fields)
> File "/home/kulin/web2py/gluon/packages/dal/pydal/objects.py", line 691, in
> insert
> ret = self._db._adapter.insert(self, self._listify(fields))
> File "/home/kulin/web2py/gluon/packages/dal/pydal/adapters/base.py", line
> 731, in insert
> raise e
> IntegrityError: FOREIGN KEY constraint failed
>
> What am i doing wrong?
>
> On Monday, December 6, 2010 at 8:50:55 AM UTC-8, rochacbruno wrote:
>>
>>
>> Is there any important difference?
>>
>> 1.
>> Field('assigned_to','list:integer',requires=IS_IN_DB(db,db.auth_user.id
>> ,'db.auth_user.first_name',multiple=True)),
>>
>> 2.
>> Field('assigned_to','list:reference auth_user'),
>>
>>
>> In the case of 2, how to represent as 'db.auth_user.first_name' for
>> multiple users?
>>
>> --
>>
>> Bruno Rocha
>> http://about.me/rochacbruno/bio
>>
>
--
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.
