Re: null values in edbi giving machine-level exception
- Posted by jeremy (admin) Nov 23, 2010
- 1277 views
Anthill said...
Thanks Jeremy! I verified that it worked. By the way, what is really the difference between edbi:query and edbi:query_rows?
query will return a query handle, you then step through each result with edbi:next(queryHandle). query_rows() does all that work for you and returns a sequence of rows. One may wonder why use query() then... the reason would be if you are doing a large query and only need to have one record in memory at a time. Say you are querying 60,000 products for an inventory report or something. Using query_rows would load each and every record into memory at the same time. Say in addition, that product query included a product image.
Jeremy