Yup I posted a correction later when I realized its not a sum that he wants but just the count of records.. I read and posted my mail with an erroneous suggestion in a hurry.. and later realized I made a mistake..
Joe ________________________________ From: LJ LongWing <[email protected]> To: [email protected] Sent: Mon, May 10, 2010 2:47:07 PM Subject: Re: COLCOUNT not working ** Joe, Sorry to disagree with you, but ‘sum’ gives you an adding of all the values in a column…whereas colcount gives you the number of records returned…. From:Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Monday, May 10, 2010 12:02 PM To: [email protected] Subject: Re: COLCOUNT not working ** Raj, sum(fieldname) is the function used across most standard databases to do something similar to a colcount() update table tablename set fieldname = sum(field2name) where your conditions... Just curious - what are your actions on your filter that doesn't seem to work? Hope this helps.. Cheers Joe ________________________________ From:Raj <[email protected]> To: [email protected] Sent: Mon, May 10, 2010 11:41:19 AM Subject: COLCOUNT not working 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"__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"
