Hi, We have some direct SQL in filter action to write data to file on server, and we also want to get a number of rows from direct SQL.
Is it possible to return the count from the SQL to remedy? We're able to get the column values from the "SQL Result Column" 1 - 10, but could find the way to get the count. "SELECT Request_Id ..." returns expected values in "SQL Result Column" 1 - 10 "SELECT COUNT(*) as Count ..." returns NULL for all columns ARS 7.0.1 P005 MS SQL 2005 Win Server 2003 MT- 7.1 P006 Microsoft IIS ServletExec/5.0p06 Andrew. Thanks _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"