The Direct DBMS returns an array so put the number of row of the array into a variable.
<@ASSIGN NAME="totalrows" VALUE='<@NUMROWS ARRAY="<@VAR resultSet SCOPE=Request>">' SCOPE="request"> Ted ________________________________ 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
