Re: [web2py] Re: How do I capture the IDs from an 'insert' [solved]

2010-11-22 Thread Lorin Rivers
I did have to create a variable to store the returned ID & then update the set using the variable. In other words: myRollUpID = db.table.insert(..) mySet.update(RollUpID=myRollUpID) On Nov 22, 2010, at 10:51 , mdipierro wrote: > I do not underatnd the question. What is you current model? > >

Re: [web2py] Re: How do I capture the IDs from an 'insert'

2010-11-22 Thread Lorin Rivers
Both tables have an int field "RollupID". The first table 'raw_data' is where I want to store the id of the insert into 'minute_table' (which will in turn store the id of the insert of the '5minute_table'). There's no reference set up in the model. On Nov 22, 2010, at 10:51 , mdipierro wrote:

[web2py] Re: How do I capture the IDs from an 'insert'

2010-11-22 Thread mdipierro
I do not underatnd the question. What is you current model? On Nov 22, 10:45 am, Lorin Rivers wrote: > Do I need to set up my model so that the source set will accept the id? > > I'm getting a KeyError on RollupID: > myset.update(RollupID=db4.array_mins.insert(..) > > On Nov 22, 2010, at 10:18 ,

Re: [web2py] Re: How do I capture the IDs from an 'insert'

2010-11-22 Thread Lorin Rivers
Do I need to set up my model so that the source set will accept the id? I'm getting a KeyError on RollupID: myset.update(RollupID=db4.array_mins.insert(..) On Nov 22, 2010, at 10:18 , mdipierro wrote: > id = db.table.insert() > > > or > > form=SQLFORM(...) > if form.accepts() >id=

[web2py] Re: How do I capture the IDs from an 'insert'

2010-11-22 Thread mdipierro
id = db.table.insert() or form=SQLFORM(...) if form.accepts() id=form.vars.id On Nov 22, 10:12 am, Lorin Rivers wrote: > I have a set that represents the records within a minute time span, upon > insert of the calculated summary into another table, I'd like to update the > source