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 web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
