To show the sales by author??™s name, you could revise the SQL statement to read
as follows:
SELECT Title, Author
FROM BookTitles, BookSales
WHERE BookTitles = BookSales AND ((Sales > 10000) AND (Sales < 20000))
ORDER by Author
The quick way to display all the fields in a table is to use a SQL statement with a wildcard, like
this:
SELECT * FROM Booktitles
The asterisk indicates that you want to choose every field. From a server resources standpoint, however, this
is an inefficient way to retrieve all records. If possible, select all your fields individually. Using the asterisk
forces the database to determine what all the field names are, instead of being told exactly what to retrieve.
Understanding How Active Content Pages Work
The journey for a static Web page from user to server is straightforward, even for the most complex, graphics-
laden, JavaScript-laden page. The user clicks a link that sends a signal to the server to send that page. An
active content page??”with full database connectivity??”travels a much different route.
An active content page is a blend of traditional HTML and a database server language such as Active Server
Pages (ASP) or ColdFusion Markup Language (CFML). When a user accesses an active content page, the
requested page is passed through the Web and database servers where the code is processed, and a new
HTML page is generated.
Pages:
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140