[web2py] Re: Insert references in a record

2011-11-22 Thread Adrian Edwards
I thought the same thing and so made date_entered capable of being empty and removed it from the form. Same result But I did find a hack workaround and it makes me wonder if my problem has to do with the user field being a foreign key and SQLFORM not liking that its empty (since I populate just be

[web2py] Re: Insert references in a record

2011-11-22 Thread Anthony
On Tuesday, November 22, 2011 11:31:21 AM UTC-5, Adrian Edwards wrote: > > form = SQLFORM(db.entries) > > form.vars.date_entered = date.today() > form.vars probably needs a string representation instead of a date object. Instead, maybe set the field's default value: db.event_users.date_en

[web2py] Re: Insert references in a record

2011-11-22 Thread Adrian Edwards
Thanks for the feedback. I have been making progress but not quit there. Massimo - I did find some logic problems with my initial select that were contributing to the problem. Anthony - I do think that how the form is being populated is part of the problem I've been trying to build this incrementa

[web2py] Re: Insert references in a record

2011-11-22 Thread Anthony
On Tuesday, November 22, 2011 12:30:42 AM UTC-5, Adrian Edwards wrote: > > 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 dat

[web2py] Re: Insert references in a record

2011-11-21 Thread Massimo Di Pierro
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 wrote: > Hello, > > I'm having difficulty getting inserts to work with tables that have > references and I'm sure its something