MACROMEDIA COLDFUSION 5-DEVELOPING Manuel d'utilisateur télécharger pdf (Page 44)

ColdFusion MX 7 Getting Started Experience Tutorial Page 44 of 47

7. Cut the query from the index.cfm page and paste it into the getArtwork function, between the cfset and the

cfreturn tags, as the following code shows:

SELECT FIRSTNAME, LASTNAME, ARTNAME, DESCRIPTION, PRICE, LARGEIMAGE, ISSOLD,

MEDIATYPE

FROM ARTISTS, ART, MEDIA

WHERE ARTISTS.ARTISTID = ART.ARTISTID

AND ART.MEDIAID = MEDIA.MEDIAID

</cfquery>

</cffunction>

</cfcomponent>

The cfreturn tag returns a query when the cffunction tag is called.

8. Save art.cfc.

9. The function is complete and now you can see it from the index.cfm page. Make sure that the index.cfm page is

open and that the Application panel is open on the Components tab, as the following figure shows. If it is not, you can

open it by selecting Window > Components from the menu bar.

10. Select the CF Components option from the drop-down list as shown in the following figure.

Figure 62. Opening the

Components panel

11. If prompted to do so, enter the RDS password you assigned when you installed ColdFusion MX 7. Click OK after you

type your password, and wait while Dreamweaver finds all of the components on your server.

1 2 ... 39 40 41 42 43 44 45 46 47

Pas de commentaire

MACROMEDIA COLDFUSION 5-DEVELOPING Manuel d'utilisateur Page 44