Dario Cardoso
|
| Posted: 02/22/2006, 4:57 AM |
|
Hi,
I use Grid for List with Data Source Type = SQL and Data Source with SQL
select store_statuses.status_name, count(order_id) as qtdpedidos from store_orders where data>=current_date and data<=current_date and order_status_id=store_statuses.status_id group by store_statuses.status_name order by status_name
I like that in runtime before execute this SQL the must modify to dates of the period that i indicate, type:
s_data1 = '01/01/2006'
s_data2 = '12/31/2006'
How i proced for this???
Thanks,
Dario.
I use PHP
|
|
|
 |
mamboBROWN
Posts: 1713
|
| Posted: 02/22/2006, 8:40 PM |
|
Dario Cardoso
How do you plan to get these dates to the page with the list?? Are you passing them as parameters in the URL (from a search form...)?? Are you using session variables??
|
 |
|
|
