So, if I use the first way you mentioned: Since, I don't have the dummy field, so do I need to add a temp field to that form. If so then still what should I be using to set the count? As the need is to set count of number of rows in the table to a field.( Table contains only one column but will have multiple rows) and then use $LASTCOUNT$ ( As COLCOUNT is not working) ? Please let me know. Thank you.
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"