> > I also tried the other method ( In a bit different syntax though: > "projects = db(db.project).select()") >
Note, db().select(db.project.customer_name) will retrieve only the customer_name field for each record from the database, so it is more efficient if that is the only field you need. Your method above returns all fields. > , this is a better method (than the sql one)? > Using the DAL for selects can make things easier, though using executesql can be a bit faster (especially for large numbers of recrods) because it doesn't parse the results into a Rows object (of course, then you lose the benefits of working with Rows and Row objects). Anthony -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
