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

ColdFusion MX 7 Getting Started Experience Tutorial Page 26 of 47

Learning Point: Database case sensitivity

The column and table names in the preceding figures are in all capital letters. This is not a requirement; it is a convention

that many database developers use. Microsoft Access is not case-sensitive, but other databases are. By following an all

caps methodology for the database and SQL statements, you can be sure that if you move your data and statements to a

different database system, it will most likely work even if the other database is case-sensitive.

See the Explore Real World Example Applications section of the ColdFusion MX 7 Getting Started Experience for other

best practices.

6. Add the fields from the ART table: ARTNAME, DESCRIPTION, PRICE, LARGEIMAGE, ISSOLD. Also add the table name

itself to the FROM statement. Your statement now looks like this:

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

FROM ARTISTS, ART

1 2 ... 21 22 23 24 25 26 27 28 29 30 31 ... 46 47

Pas de commentaire

MACROMEDIA COLDFUSION 5-DEVELOPING Manuel d'utilisateur Page 26