Thanks for the reply. so, DB ID of Table Name = Table1 DB ID of Column in the table = Column Field ( Only one column in this table ) then my Set Field with SQL Source should look like : SELECT COUNT(Column FIeld) FROM Table1 WHERE query ?
Please let me know. Thanks. On Mon, May 10, 2010 at 9:09 AM, ARSmarts Support <supp...@arsmarts.com>wrote: > ** > Hi, > > You can make a filter with 2 set field actions: > - the 1st one is just setting a dummy field with the result of the query > you want to count the results > - the 2nd one uses the $LASTCOUNT$ keyword > > or > you use a set field with SQL source, and write a query like SELECT > COUNT(Field1) FROM table_Name WHERE query > > Best regards, > ARSmarts support team > > > > ARSmarts, your most useful AR System companion. > www.ARSmarts.com > > On 10 May 2010, at 17:41, Raj wrote: > > Hi All, > Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields > action of a Filter on Submit. Seems is it not working. Always setting > the field to a constant value of 15. > Would like to set the field with the number of rows in that particular > table. Is the any other way around to do this? > How can it be done with the help of Direct SQL ? > > Please advise. > Thanks, > Ravi > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > > > > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
