Witango-Talk:
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 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: Wednesday, April 22, 2009 12:24 PM To: witango-talk@witango.com 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 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: <@totalrows>
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] Sent: Wednesday, April 22, 2009 12:24 PM To: witango-talk@witango.com 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
RE: Witango-Talk: <@totalrows>
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: Wednesday, April 22, 2009 12:24 PM To: witango-talk@witango.com 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
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
Re: Witango-Talk: WiTango with SQL Server 2005 Database Mirroring
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 to do some more experimentation. I will update this group when I have some progress. Thanks again. Rob Trahan -- This message was sent on behalf of rob.tra...@yahoo.com at openSubscriber.com http://www.opensubscriber.com/message/witango-talk@witango.com/11972640.html TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf