Thanks for the suggestions. Robert, the behavior you describe is exactly what
I'm seeing. Unfortunately the quick test I gave it (failing over the database
then restarting services) didn't work. However, I'll have to wait until this
evening when developers aren't using our testing environment
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 specifyin
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:stevefogel...@askics.net]
Sent: Wedn
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:stevefogel...@askics.net]
Thanks guys. Appreciate the quick answers.
Steve
_
From: Walker, Buddy [mailto:bu...@medschool.pitt.edu]
Sent: Wednesday, April 22, 2009 11:30 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: <@totalrows>
Steve
I think you would have to make two hits to the databa