There is no mechanism for temporary tables.
The options are
1) user db.executesql to define the temporary table then make it
visible to web2py DAL using db.define_table
('yourtemptable',....,migrate=False)
2) use a Rows object instead of a temporary table.If you show us an example of the raw SQL you would use, we can perhaps provide a more concrete example of solution. Massimo On Oct 14, 11:46 pm, wf321 <[email protected]> wrote: > in web2py is there anything like tempory table and store procedure ? > > people not suggest to use tempory table for DAL > > but what is the good solution to handle complex query? > > For example, there are tables A,B,C,D,E ... > > 1) result1 = join A,B,C > > 2) update some rows in result1 > > 3) then base on rows count of result1, need join result1 to > different > table (C.. or D,E..) and return different fields > > handle this can use tempory table in store procedure in database , > anyone know how to do it in web2py with DAL (not db.executesql ) ? > > thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---

