[thelist] ColdFusion Tip

<tip type="ColdFusion" subject="Trimming The Fat">

Do you have ColdFusion queries that are meant to pull only one record?

Use the 'maxrows' attribute in your cfquery tag set to 1; it will speed the
query up (database stops searching after it finds the first match), and it
acts as a kind of built-in comment for those who will be looking at your
code down the road.

example:
<cfquery name="MyQuery" datasource="MyDatasource" maxrows="1">

</tip>

Take Care,

Seth