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.
Managing your code with versioning software will save you countless hours.No developer should overlook the possibilities of versioning software to keep his development machine tidy and manage his files. I found Microsoft Visual SourceSafe an indispensible asset when developing. It is easy to use and saved me an enormous amount of time.
A short SQL Server 2000 tutorial about upsizing a MS-Access database to SQL Server.
The project used is the standard Access database that comes with the Learningsite command for Dreamweaver.
A short SQL Server 2000 tutorial explaining how to script a complete database with roles and logins and all other objects for a future empty database that resides in a single .sql text file.
The project used is the upsized Access database that comes with the Dreamweaver Learningsite command.