Paul
|
| Posted: 01/31/2002, 2:55 AM |
|
I have used this code in the 'Open' Event for a form to display the number of vacancies found:
sSQL="select count(vacancy_id) as v_vacancy_id from vacancies as v"
however this produces the total for the whole table, how could i limit this to just the total of vacancies found in a single division (i.e. division_id = 3)
|
|
|
 |
Alex Alexapolsky
|
| Posted: 01/31/2002, 5:10 AM |
|
If this page has received division id parameter you can build ssql like this
sSQL="select count(vacancy_id) as v_vacancy_id from vacancies as v where division_id=" & GetParam("division_id")
|
|
|
|
|
