Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - jarry

1
General Discussion / How to query Count Components filtered to Current View Record?
Hello everyone,

I've tried to construct a SQL query for the COUNT COMPONENT to limit records to the current record VIEW.  But to no avail.  Please help.

current view:
purchases/view    primary field='pur_id'

sql for the count component:
"SELECT COUNT(*) AS num FROM purchase_details WHERE pur_id=?"   

parameter:
$data['pur_id']
Not working.