MACROMEDIA COLDFUSION 5-DEVELOPING Manuale Utente Scaricare il pdf (Pagina 32)

ColdFusion MX 7 Getting Started Experience Tutorial Page 32 of 47

7. Since you have verified that the data is being retrieved from the database, you no longer need the cfdump tag.

However, rather than remove it (since you might need it again), you can just use a ColdFusion comment to comment

it out of the page, as the following figure shows. Doing so tells ColdFusion to ignore that command.

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

FROM ARTISTS, ART, MEDIA

WHERE ARTISTS.ARTISTID = ART.ARTISTID

AND ART.MEDIAID = MEDIA.MEDIAID

</cfquery>

Learning Point: CFML comments

HTML comments have only two dashes on each side of the comment; CFML comments have three dashes.

However, the difference between an HTML and a CFML comment is profound. CFML comments, like other ColdFusion

tags and variables, are stripped out of the page. Therefore, you can use CFML comments liberally without worrying about

them showing up in the browser’s view source.

8. You need to display the database data in the table. To start, remove all of the rows except for one and all of the cells

in that one row except for one, as the following code shows:

<tr>

Artist: Austin Weber<br>

Price: $75,000.00<br>

Painting - Charcoal<br>

</td>

</tr>

</table>

You will use CFML to generate all of the rows and cells that you need.

9. Replace the image filename, artwork name, artist’s name, price, media type, description, and sold status with the data

that was retrieved in the artwork variable. Do this by referencing the variables and surrounding them with number

signs, as the following figure shows:

<tr>

<strong>#artwork.artName#</strong><br>

Artist: #artwork.firstName# #artwork.lastName#<br>

Price: #artwork.price#<br>

#artwork.mediaType# - #artwork.description#<br>

<font color="#FF0000">#artwork.isSold#</font>

</td>

</tr>

</table>

1 2 ... 27 28 29 30 31 32 33 34 35 36 37 ... 46 47

Nessun commento

MACROMEDIA COLDFUSION 5-DEVELOPING Manuale Utente Pagina 32