Generally speaking, when you do a query, you want the results of your query, not just the number of records. The original poster implies that this is what (s)he's looking for. It's inefficient to do two queries when one will suffice. So when you do the following, you get the number of records, as well as the result set that can be used in a dtml-in. <dtml-let results="SQL_Select()"> #Results returned = <dtml-var "_.len(results)"> </dtml-let> However, as somene has already pointed out, it's probably best/easiest to use the sequence-length variable defined by the dtml-in. However, if someone just wants a count of records from a db query, and not the records themselves, then you're right, just use SQL. Mark
True enough you could, but why?
SQL has the correct tools for the job!
----- Original Message ----- From: "Mark N. Gibson" <mark@kaivo.com> To: "Sheree Beaudette" <sheree@psouth.net> Cc: <zope@zope.org> Sent: Wednesday, July 25, 2001 10:16 PM Subject: Re: [Zope] Simple, I think!
You could do this:
<dtml-let results="SQL_Select()"> #Results returned = <dtml-var "_.len(results)"> </dtml-let>
Mark
I've looked everywhere and I think this should be simple but I'm not
getting
it
I simply want to count the number of records generated by an ZSQL Method (SQL query) within a DTML Method (something like get the record count of that certain query). I then want to refer to this number (could be zero if there are no records) and say if this number is zero then do something, else do something else.
Can anyone help??
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )