db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From peter riegersperger <r...@subnet.at>
Subject Count(*) and criteria
Date Sun, 02 Feb 2003 17:16:32 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello!

i'm using torque as part of a turbine project, and have spent some time now 
trying to figure out something i think is fairly basic:
i'm using paginated lists of entries (limit and offset), but i need to know 
the number of total records for the given query (without limit and offset 
set) to calculate the total number of pages.
i don't want to run the complete query (because i don't need the records), i 
just want to get a "Count(*) from ... where ..."

how can this be done? i've tried and read the javadoc, and the tutorials and 
the list archive, but to no avail. is the solution _that_ obvious? (i sure 
hope not ... ;)

i'd be greatful for any help, i'm definitely completely without the slightest 
idea.

regards,

rick

- -- 
|-
| peter riegersperger  <rick@subnet.at>
|-
| ein windows switcher tagebuch:
| http://forum.subnet.at/viewforum.php?f=22
|-
| subnet
| platform for media art and experimental technologies
|-
| http://www.subnet.at/
|-
| muehlbacherhofweg 5 // 5020 salzburg // austria
|-
| fon/fax +43/662/842 897
|- 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+PVJ1IMP39JYOy9IRAsxfAKDIHIu0lHvmMxBTJmROwMjfya5JZQCg6i3H
hVbvbsftcWZO0/Z5knknosM=
=8neH
-----END PGP SIGNATURE-----


Mime
View raw message