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.


Reply via email to