How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
ASP Dds Tutorials
Multiple Form Selection
Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input from the dropdown menu comes through comma delimited it is simply written into the statement without modification. Two simple for next loops determine which elements are part of the record set and displays them accordingly.
Multiple Form Selection (Where In)
Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin" Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected.
Date Dependent Content
The author notes "Displaying content depending on what the current date value is a powerful and effective tool that adds value to any website. Whether it is to showcase a limited time offer, or to "automatically" update pages with new content while you"re miles away." This example code repeats the process to three times to demonstrate the full effects of date dependent content.
Print View (From a db template)
Web pages usually print pretty lousy. Typically, background colors are not displayed (unless you change the browser settings) and depending on site the width may be set much wider than the printer can handle on the horizontal for a page. Providing a printer friendly format adds immeasurable value for your users. This example demonstrates how to strategically place a couple of simple tautologies that will display banners and other items in the typical or "default" view and allows a link back to the same page with a querystring value that will be used to suppress everything but the db output.