This may be really simple but

Posts   
 
    
DAVE30B
User
Posts: 8
Joined: 12-Oct-2007
# Posted on: 12-Oct-2007 17:02:31   

I am doing a FAQ section and i need to no the count of records between each catagory to display

FAQ CATEGORY [ RECORD COUNT]

NOW IN SQL I would Normally use the count command but since i am just refernece the categories display how do i go about this with llbgen

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 12-Oct-2007 17:25:46   

Please check the Scalar query expressions in the manual "Using the generated code -> Field expressions and aggregates"

Also check the following thread if you want to add this extra property to your entity: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=10287