Hi All I have two tables in my database, e.g. customer order_request ( having a reference of customer)
I am trying to implement the search to find all order by a customer. so I am wring the code as follow. I have not created any view, I am using generic view to see the output. def find(): form, rows = crud.search(db.order_request) return dict(form=form, rows=rows) when pressing the submit button on the page ( without any entry) .. it produce all order_request entries as expected. but if I make a filter, like customer_id equals 1 -> does not produce rows. and clicking in db stats button i could see the command SELECT order_request.id, order_request.customer_id FROM order_request WHERE (order_request.id > 0); 0.00ms Could someone please throw some light, what wrong i am doing. ---- Web2Py version I am using is Version 2.4.6-stable+timestamp.2013.04.06.17.37.38 --- Thanks Sanju -- --- 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.