MACROMEDIA COLDFUSION 5-DEVELOPING Bedienungsanleitung PDF herunterladen (Seite 33)

ColdFusion MX 7 Getting Started Experience Tutorial Page 33 of 47

Learning Point: Deconstructing the query variable syntax

Keep in mind the following rules regarding correct query variable syntax:

• Surround variables with number signs (#).

• Remove all spaces.

• Prefix the variable name by using the cfquery tag’s name attribute value (in this case, artwork).

• Follow the prefix with a period.

• Follow the period with the column name from the SELECT statement that you want to display.

Remember that ColdFusion is not case-sensitive, so while the column names are in all caps in the SELECT statement,

you write them here in mixed case. The case does not matter, but the coding methodology for this project uses mixed

case for ColdFusion variables. To see other methodology guidelines, see the Explore Real World Example Applications

section of the ColdFusion MX 7 Getting Started Experience.

10. Save the index.cfm page and browse it.

Figure 50. Variables don’t

get processed properly just

because you put number

signs (#) around them.

Again, ColdFusion treats the variables as text. This is because number signs alone do not signal a ColdFusion

variable, because they are often used in regular text that might appear on the page.

11. In order for ColdFusion to recognize that the number signs are variable indicators, you surround the section with

cfoutput tags, as the following code shows:

<tr>

#artwork.artName#

Artist: #artwork.firstName# #artwork.lastName#

Price: #artwork.price#

#artwork.mediaType# - #artwork.description#

#artwork.isSold#

</cfoutput>

</td>

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

Keine Kommentare

MACROMEDIA COLDFUSION 5-DEVELOPING Bedienungsanleitung Seite 33