Adobe 38043740 Developing Applications - Page 588

DEVELOPING COLDFUSION 9 APPLICATIONS 583 ColdFusion ORM Note: In case of more than one parameter, values are picked up based on the parameter sequence, for example, the first parameter will be replaced by first value and second parameter will be replaced by second value. Examples: named parameters This type of ORMExecuteQuery lets you pass named parameters to the query. The placeholder for the parameter should be a name and should start with ":" as in ":age" or ":id". The values to the names should be passed as key-value pairs. For example, to retrieve artist details of all artists whose reside in USA and are also citizens of USA, your code should look like this: Note: Parameters are not case-sensitive. Examples: group by This type of ORMExecuteQuery lets you retrieve aggregate or grouped values for the query. For example, to retrieve the first name and last name along with the status of the artwork being sold or not, you can write a query similar to the following: #artistItem[1]# #artistItem[2]# #artistItem[3]# Note: Built-in functions to obtain the data such as getFirstName() or getLastName() cannot be used if you are using select queries with specific column names. The result will be returned as an array object and values can be retrieved using array index. Example: order by This type of ORMExecuteQuery lets you retrieve sorted data from a data source using the order by clause. For example, to sort the data from the Artist table by firstname, use the following code: Name = #artistObj.getFirstName()# #artistObj.getLastName()# Example: aggregate functions This type of ORMExecuteQuery lets you retrieve data when using aggregate functions such as sum, count, avg. #artist# Last updated 1/20/2012