Steve I think you would have to make two hits to the database. One retrieving the rows you want then do a
SELECT COUNT(*) FROM tableName WHERE ..... Then assign a variable with the value of <@NUMROWS> Buddy From: Fogelson, Steve [mailto:[email protected]] Sent: Wednesday, April 22, 2009 12:24 PM To: [email protected] Subject: Witango-Talk: <@totalrows> Probably should know this! The Search Action provides a check box to return a number that will be provided by the tag <@totalrows> indicating the total number of rows matching the criteria specified in the Search action. The Direct DBMS action does not provide this check box. I am specifying the number of rows to retrieve and <@totalrows> will be different from <@numrows>. Is there a way to get the totalrows without retrieving all of them, same as in the Search Action? FYI: I am using MySQL. Thanks Steve Fogelson ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
