-----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-----