I do not understand your test.

On Oct 31, 7:15 pm, Thadeus Burgess <thade...@thadeusb.com> wrote:
> I am attempting to use the new DAL feature, where you can do a select,
> and take the first row and insert that row into the reference column
> of the database as a reference.
>
> I get the following error. This is fixed by just referencing row.id.
>
> Did I misunderstand, this new feature was for inserts as well as just 
> selecting?
>
> Traceback (most recent call last):
>
>   File "gluon/restricted.py", line 184, in restricted
>
>     exec ccode in environment
>   File line 238, in <module>
>
>   File ** "gluon/globals.py", line 103, in <lambda>
>
>     self._caller = lambda f: f()
>
>   File ** line 214, in controller
>
>     referred_by=referred_by, ### THIS IS THE ROW RETURNED BY
> db...select().first(), this is fixed by just referencing .id
>   File "gluon/sql.py", line 1681, in insert
>
>     self._db._execute(query)
>
>   File "gluon/sql.py", line 838, in <lambda>
>
>     self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> DataError: value too long for type character varying(1)
>
> -Thadeus
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to