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: > I do not underatnd the question. What is you current model? > > On Nov 22, 10:45 am, Lorin Rivers <lriv...@mosasaur.com> 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 , mdipierro wrote: >> >> >> >>> id = db.table.insert(....) >> >>> or >> >>> form=SQLFORM(...) >>> if form.accepts(....) >>> id=form.vars.id >> >>> On Nov 22, 10:12 am, Lorin Rivers <lriv...@mosasaur.com> 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 set with the ID of the inserted record. >> >>>> How do I do that? >>>> -- >>>> Lorin Rivers >>>> Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> >>>> <mailto:lriv...@mosasaur.com> >>>> 512/203.3198 (m) >> >> -- >> Lorin Rivers >> Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> >> <mailto:lriv...@mosasaur.com> >> 512/203.3198 (m) -- Lorin Rivers Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> <mailto:lriv...@mosasaur.com> 512/203.3198 (m)