ColdFusion组件的使用

１.art.cfc

<cfcomponent>
    <cffunction name="getArtwork" access="public" returntype="query">
        <cfset artwork="">
        <cfquery name="artwork" datasource="cfgettingstarted">
        SELECT FIRSTNAME, LASTNAME, ARTNAME, DESCRIPTION, PRICE, LARGEIMAGE, ISSOLD, MEDIATYPE
        FROM ARTISTS, ART, MEDIA
        WHERE ARTISTS.ARTISTID = ART.ARTISTID
        AND ART.MEDIAID = MEDIA.MEDIAID
        </cfquery>
        <cfreturn artwork>
    </cffunction>
</cfcomponent>

 

 

2.index.cfm

<cfinvoke
 component="cf8gettingstarted.tutorial.art"
 method="getArtwork"
 returnvariable="artwork">
</cfinvoke>

<!---或者

<cfscript>
    obj = createObject("component", "cf8gettingstarted.tutorial.art");
    comment = obj.getArtwork();
</cfscript>

--->

<cfoutput query="artwork">

        Artist: #artwork.firstName# #artwork.lastName#<br>
        Price: #dollarFormat(artwork.price)#<br>
        #artwork.mediaType# - #artwork.description#<br>

</cfoutput>