folkerts
|
Posted: 02/17/2004, 7:35 AM |
|
hi, i use the following sql for a grid form
select omschrijving,code,entypeid from en WHERE entypeid LIKE '%%' AND (code LIKE '%%' or code is null) and (omschrijving like '%%' and omschrijving like '%de%' ) group by omschrijving,code,entypeid
now the pagenavigator should determin de number of pages. this works with $formname->ds->CountSQL . this count sql based on the select sql. ($formname->ds->SQL) in the following way.
$formname->ds->CountSQL = "select count(*) from ($formname->ds->SQL) as cnt.
in my case this doesnt work. am i doing something wrong here? i guess i am but in postgres forums/docs i cnnt find sollutions for this problem
|