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? > > 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)
