Welcome to imar.spaanjaars.com

image
Welcome to the personal web site of Imar Spaanjaars where I write about software development with a focus on Microsoft web technologies
Image representing the FAQs category

How Do I Select Duplicate Records from a Database Table

Published 17 years ago

This T-SQL snippet allows you to select duplicate records from a database table. The example assumes that the column Id is used to determine whether a record has a duplicate. If multiple columns determine whether a record has a duplicate or not, simply expand the SELECT list and the GROUP BY clause.

Read on ...
Image representing the Blogs category

Site Update

Published 17 years ago

Today I finally got to updating the site....

Read on ...
Image representing the Snippets category

Preventing a Page from Being Cached by Browsers and Proxy Servers

Published 17 years ago

Add the following code to the top of your ASP page to prevent it from being cached by the browser or any intermediate proxy or caching server. This will force the browser to retrieve a new copy of the page, everytime it needs to display it.

Read on ...
Image representing the Articles category

Allowing Your Users to Sign Up for Your Site

Published 17 years ago

If you have a copy of the book Beginning Dreamweaver MX, I am sure you are familiar with the project TheSoccerSite. For those not familiar with the project, TheSoccerSite is a Web site where soccer fans around the world go for up-to-date information about soccer events. In 7 Chapters, Server- and Client-Side programming, using ASP, HTML, JavaScript and a Microsoft Access database were introduced. One of the features of the site was a login mechanism to protect the admin section from unauthenticated and unauthorized users.

However, with the current implementation of the login mechanism, you would have to add new users to the database directly. To do this, you'd need to download the database, add the user and then upload the database again. Fortunately, Dreamweaver has a few handy Server Behaviors that make adding a new user to the database very easy.

Read on ...
Image representing the Blogs category

Book Update

Published 17 years ago

Pffff, my part of the book Beginning Dreamweaver MX 2004 is done. Last weekend I sent in the latest versions of my Chapters, so as far as my contribution is concerned, the book is done.

Read on ...
Image representing the Blogs category

New Article About Forcing the Save As Dialog in a Browser

Published 17 years ago

Yesterday I published a new article that answers a very frequently asked question: "How can I force the browser to present the Save As dialog, instead of having the file opened by the browser?" I published it in the ASP category of the Articles section, because it was a bit too long for a FAQ. You can find the article here.

Read on ...
Image representing the Articles category

Howto Force the Save As Dialog in the Browser

Published 17 years ago

Your Web browser is set up to handle all kinds of documents. For example, when you open an .html page from a Web site, the browser knows it should parse this file, and display its rendered contents onscreen. The same is true for images; when you click on a link that directly links to an image, the image will be displayed in the browser.

This default behavior may not always be what you want. In some scenario's, it's useful to have the user download and save the file, instead of displaying it in the browser. This is a common requirement for files like images, Word documents, spread sheets and so on. This article will demonstrate you how you can force the client browser to present the Save As dialog, so your users can download the file and save it on their local hard disk.

Read on ...
Image representing the Blogs category

Delay in Site Updates

Published 17 years ago

I am currently working very hard to finish my new book, Beginning Dreamweaver MX 2004. It's a lot of work, but it's worth it; the book is going to be great.

Read on ...
Image representing the Blogs category

Added the About My Books section

Published 17 years ago

Today I added page called About My Books to the About section of the site menu.

Read on ...
Image representing the Blogs category

Added an About Section

Published 17 years ago

I added an About section to the Site Menu. Currently it features just an About This Site but I'll add About Me and About My Books sections shortly.

Read on ...

Mobile: False

Crawler: True

I: False