<CFQUERY NAME="Catalog" DATASOURCE="ProductCatalog">
    SELECT Name, Size, Price FROM Product;
</CFQUERY>
<CFOUTPUT QUERY="Catalog">
    #Description#, #Size#, #Price#<BR>
</CFOUTPUT>

Example 1: Querying a database using CFML.

Back to Article