RE: One more: rowcounts with DODS standalone!

Ok!

I understand now that the method works as a switch
modifying the SQL statement.
I looked a bit at the source code of the Query classes
generated and I get the impression that the caching
mechanism isn't involved. Will the result still be
cached?

Thanks for your help!

Axel




 --- Madl Alfred <A.Madl@xxxxxxxxxxx> schrieb: > When
using selectCount() you simply switch the SQL
> clause from SELECT T1.*
> FROM.... to SELECT count(*) FROM...
> 
> Everyting else is working the same as with normal
> queries...
> 
> Alfred
> 
> -----Original Message-----
> From: Axel Wilhelm Berle [mailto:axelberle@xxxxxxxx]
> 
> Sent: Mittwoch, 17. Dezember 2003 13:07
> To: enhydra@xxxxxxxxxxx
> Cc: Madl Alfred
> Subject: One more: rowcounts with DODS standalone!
> 
> Thanks Alfred,
> 
> That was exactly what I needed! By accident I
> stumbled
> over the selectCount() method which seems to be the
> solution to another problem we are facing: how to
> count the number of rows of a query!
> 
> My question is: does selectCount() cache the
> results?
> Or is it recalculated all the times it is called?
> 
> 
> Thanks in advance!
> 
> Axel
> 
> 
> 
> 
> 
> 
> Subject: AW: Enhydra:  Browsing of tables with DODS
> Date: Tue, 16 Dec 2003 22:26:01 +0100
> From: "Madl Alfred" <A.Madl@xxxxxxxxxxx>
> To: <enhydra@xxxxxxxxxxx>
> Reply-To: enhydra@xxxxxxxxxxx
> 
> Hi !
> 
> xxxQuery classes support "readSkip" and
> "setDatabaseLimit" methods to 
> do
> that ! "databaseLimitExceeded" even tells you, if
> there would be more
> data following...
> 
> Greetings.
> 
> Alfred
> 
> -----Urspr=FCngliche Nachricht-----
> Von: Axel Wilhelm Berle
> [mailto:axelberle@xxxxxxxx]=20
> Bereitgestellt: Dienstag, 16. Dezember 2003 15:03
> Bereitgestellt in: Enhydra
> Unterhaltung: Enhydra: Browsing of tables with DODS
> Betreff: Enhydra: Browsing of tables with DODS
> 
> 
> Hi!
> 
> I have a practical question concerning browsing of
> tables with DODS (standalone). I need to retrieve
> the
> contents of a table in pages. In the old version of
> DODS I constructed manually a query using the SQL
> OFFSET and LIMIT feature.
> 
> What would be the best DODS way to browse a table,
> page for page, without the need to get the entire
> table at once and throw away the unneeded parts?
> 
> Thanks in advance,
> 
>    Axel
> 
> 
> Axel Wilhelm Berle
> 
> e-mail: axelberle@xxxxxxxx
> Tel: (office) +55 16 618.0090
>      (mobile) +55 16 9964.6343
> 
> 
> 
> =====
> Axel Wilhelm Berle
> 
> e-mail: axelberle@xxxxxxxx
> Tel: (office) +55 16 618.0090
>      (mobile) +55 16 9964.6343
> 
>
__________________________________________________________________
> 
> Gesendet von Yahoo! Mail - http://mail.yahoo.de
> Logos und Klingeltöne fürs Handy bei
> http://sms.yahoo.de
> 

> ATTACHMENT part 2 application/x-pkcs7-signature
name=smime.p7s
 

=====
Axel Wilhelm Berle

e-mail: axelberle@xxxxxxxx
Tel: (office) +55 16 618.0090
     (mobile) +55 16 9964.6343

__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
Logos und Klingeltöne fürs Handy bei http://sms.yahoo.de