count()
Description
Returns the number of rows that match the arguments (or all rows if no arguments are passed in). Uses the SQL function COUNT.
Function Syntax
count([ where, include ])
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
where |
string |
No | |
An SQL fragment such as lastName LIKE 'A%' for example. |
include |
string |
No | |
Any associations that need to be included in the query. |
Examples
<!--- Count how many authors there are in the table --->
<cfset authorCount = model("author").count()>
<!--- Count how many authors whose last name starts with "A" there are --->
<cfset authorOnACount = model("author").count(where="lastName LIKE 'A%'")>
<!--- Count how many authors that have written books starting on "A" --->
<cfset authorWithBooksOnACount = model("author").count(include="books", where="title LIKE 'A%'")>
<!--- Count the number of comments on a specific post (a `hasMany` association from `post` to `comment` is required) --->
<!--- The `commentCount` method will call `model("comment").count(where="postId=#post.id#")` internally --->
<cfset aPost = model("post").findByKey(params.postId)>
<cfset amount = aPost.commentCount()>
Vivio Technologies.