[Zope] sql query

Graham Chiu anon_emouse@hotmail.com
Tue, 11 Apr 2000 13:48:10 +1300


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In article <38F23842.A889B4E4@messagemedia.com>, Ken Kinder
<kkinder@messagemedia.com> writes
>I take it you just want the number of rows returned from a query. Try
>a query like this...
>
>       select count(*) from table where [...]

You probably need to do this as your sql query

select count(*) as total from table where <dtml-sqltest ... >

and then use ( <dtml-var TOTAL> )

- -- 
Regards,        Graham Chiu
gchiu<at>compkarori.co.nz
http://www.compkarori.com/dynamo - The Homebuilt Dynamo
http://www.compkarori.com/dbase - The dBase bulletin

-----BEGIN PGP SIGNATURE-----
Version: PGPsdk version 1.7.1

iQA/AwUBOPHbmrTRdIWzaLpMEQLejQCg2l0/hKecOJcg6EaFMNv+4Ie1eAUAn0o5
FbNS3lCWKP0H4m9pp44NDzWG
=M0fo
-----END PGP SIGNATURE-----