• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Recipe 6. Time Cards > Recipe Overview: Data Source Tables and Queries

Recipe Overview: Data Source Tables and Queries

The Time Cards recipe is somewhat different from the others in this book. Many of the application pages, especially those displaying time card summaries, are calculation intensive. Although it’s possible to include the required complex SQL statements on the Web page, it’s far more efficient—and far less error-prone—to construct and execute the SQL within the database itself.

The Time Cards recipe follows the approach of keeping the complex SQL in the data source. Consequently, creating the actual application pages is fairly straightforward with a minimum of hand-coding required. However, to truly understand how the recipe works, we’ll need to take a little time to examine the component parts of this application: the data source tables and the queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint