I see. Thanks Henner.
One more question:
Is there a way in which I can retrieve the complete query statement,
i.e.,:
1- the part defined in dbforms-config.xml, plus
2- the whereClause defined in dbform tag
So that I can do something for example like:
Select count(*)
>From (complete_retrieved_query_statement)
This is just so that I don't have to hard code the complete query again.
Thanks!
Julio Ortuzar
-----Original Message-----
From: Henner Kollmann [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 12:58 PM
To: 'Julio Ortuzar O.'
Cc: [EMAIL PROTECTED]
Subject: AW: [dbforms] Record Count
Fetched with maxrows=0?
Otherwise this can not work. Dbforms do not know the the size of the
resultset until all data is fetched. Only known is if there are more
records then shown.
You can use rsv.isLastPage() to check for this. It will be true if
lastpage is reached.
Attention: Works only with datalist navigation!
Regards,
Henner
> -----Urspr�ngliche Nachricht-----
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im
> Auftrag von Julio Ortuzar O.
> Gesendet: Dienstag, 14. Oktober 2003 16:27
> An: [EMAIL PROTECTED]
> Betreff: [dbforms] Record Count
>
>
> Hi I have tried to get a global record count on a query I
> have defined in dbforms-config.xml file.
>
> I tried with
>
> <%= rsv_qry_asoex.size() %>
>
> But,it only shows the amount of rows delimeted by the maxRows
> attribute of the dbform tag (in case
> maxRows>=rsv_qry_asoex.size()). I wouldn't think doing a
> count(*) on the same query would be efficient since that
> information must be stored somewhere.
>
> Any ideas, clues???
>
> Thanks,
>
> Julio Ortuzar
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> SourceForge.net hosts over 70,000 Open Source Projects. See
> the people who have HELPED US provide better services: Click
> here: http://sourceforge.net/supporters.php
> _______________________________________________
> DbForms Mailing List
>
http://www.wap-force.net/dbforms
-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
