I am pretty sure the error is not the code you showed us. You are
somwhere assigning something to =T(...) where it expects a string.
On Nov 21, 11:30 pm, Adrian Edwards <aedward...@gmail.com> wrote:
> Hello,
>
> I'm having difficulty getting inserts to work with tables that have
> references and I'm sure its something stupid I'm doing wrong.
> Hopefully you guys can point me in the right direction.
> I have the following 2 tables.
>
> db.define_table('event_users',
> Field('event', 'reference events'),
> Field('user_name', 'reference auth_user'),
> Field('goal', 'double'),
> Field('last_entry', 'date'),
> format = lambda row: "%s - %s" % (row.event.name,
> row.user_name.first_name))
>
> db.define_table('entries',
> Field('user', 'reference event_users'),
> Field('date_entered', 'date'),
> Field('value', 'double'),
> format='%(user)s %(date_entered)s')
>
> I'm trying to insert a record into the entries table. I have the
> following SQLFORM to generate the view and then try to pre-populate
> date_entered and user. User is calculated and is equal to Reference
>
> form = SQLFORM(db.entries)
> form.date_entered = date.today()
> form.user = user
> if form.process().accepted:
>
> But the form won't submit. When I debug it through Eclipse it says
> "lazyT: value not in database"
>
> Any suggestions?
> thanks
> Adrian
