This tutorial will walk you through the following:
A short reference document to some of the Date / Time functions in SQL Server.
Many webdesigners have discovered that Dreamweaver now gives them the power to develop cool webapplications. In this way you can cross the border between graphical design and web application developers. We have seen a lot more basic starter questions in the Talkzones reflecting the will of many designers to explore these exciting possibilities. Questions like: "I want to build an E Commerce site for a client. Can anyone write a tutorial on how to get started with ASP and MS Access?"
Let's start with the real basic questions first. Like what programming language are you going to use? This is a major decision to make. When i got started developing as a former webdesigner a few years ago, it took me a long time to figure out.
Filtering records using dynamically generated checkboxes or Multiple selection lists
There is an excellent extension and a good tutorial available for deleting and updating records using checkboxes and multiple slection lists. This is based on tweaking the command-options in Dreamweaver. But when you want to use dynamically generated checkboxes or multiple selection lists to filter records, you are virtually on your own. An integrated solution for Dreamweaver is high on my whishlist, but untill then we have to do some handcoding.
The code below is simplified for clarification. There are some more issues to this. It now uses an OR-operator which is not allways the most elegant way to retrieve data from the DB. In a next article i will cover the use of the IN operator in SQL and Dreamweaver, which does a better job. Trying to use the IN-Operator with Dreamweaver can be a very "interesting experience" since MM forgot about this very handy and common option in SQL as well.