Explore the Articles

Databases

Upsizing Microsoft Access-Based Applications

The purpose of this paper is to enable the developer of Microsoft® Access-based applications to use and understand fully the Microsoft Access Upsizing Tools. The developer should be able to use the tools to facilitate client/server development between Microsoft Access and Microsoft SQL Server™. The paper will discuss design strategies for using the tool optimally in the development process.

Read More
Manuals

Creating Custom Objects in Ultradev

This tutorial will introduce to you the Objects feature in Dreamweaver and UltraDev, providing a basic grounding in the subject.  In subsequent articles we will go on to discuss more complex scenarios, but to begin with, we’ll keep it nice and simple.

Read More
Server Side

Set the ASP Locale ID Per the Browser's Language Settings

When creating an Active Server Pages (ASP) application that will be accessed from multiple international sites, it is beneficial to modify the Locale settings so that the VBScript Date, Time, Currency, and so forth formats will return the appropriate format for the user's location.

Read More
Server Side

Dynamically resize an image

As developers, we're often called on to create picture galleries, thumbnails to larger images, and with an ecommerce site, product pages where all the images need to fit within a constrained image size. With the wonders of ASP (and 4guysfromrolla), we're going to do just that. All the code for this method was created by 4guysfromrolla, I'm just going to give you a slightly less convoluted (and technical) explanation on how to implement it.

Note: for more advanced server side image resize check out the Smart Image Resize 

Read More
Server Side

Global Error Handling in IIS5 with Mail Notify

In this tutorial I will explain how to easy it is to make a global error page that will be displayed each time an error occurs. Here are some objectives we will try to archive:

  • The page should be executed on each ASP error
  • The error page will be customized to the appearance of the site.
  • An e-mail shall be sent to the administrator when the error page executes to inform him about the error.

This is a very neat solution because we don't want to have a very extended error handling on each page. And even if we put such handling on each page - there are so many errors that can occur - we will never be able to handle them all.

Read More
JavaScript

Creating client-side dynamic dependent list boxes

Client-side dynamic dependent list boxes allow a "child" list box to refresh when a selection is made in a "parent" list box, without having to return to the server. Most dynamic dependent list box models return to the server to requery the dependent list box's recordset. The model described in this TechNote passes dependent list box data to the browser in an array. It uses JavaScript to extract the appropriate values from the array and refresh the "child" list box in the client's browser.

The advantage to this approach is immediate page response; the user does not have to wait for the new page to be delivered from the remote server. The disadvantage is all the data for the dynamic dependent list box is sent to the client as text, thus increasing the size of the requested page. An evaluation must be made whether the increased page size warrants saving return trips to the server. If the amount of data required for the dynamic dependent list box is not significant, page size remains relatively small.

Read More
Server Side

Deleting multiple records via checkboxes

This is the first of 2 tutorials on batch record deleting. The first tutorial requires a minimum experience with UD's forms and live data. a short manual coding is required in the delete page.

The second tutorial shows you how to delete, along with the records, the files on the server the records point to. Typically this is the case with image files, that have been uploaded to the server and whose path is stored in a database table.

If you delete just the records, the image files will be left on the server, using up precious space. Read More

The Zen of Recursion

Use SQL Server stored procedures recursively to traverse hierarchies

Chris Behrens

Recursion is the property or quality of self-reference. In programming terms, recursion refers to a routine that repeatedly calls itself until a certain condition is fulfilled. One powerful way that SQL Server database developers can use recursion is to traverse hierarchies—collections of items that have parent-child relationships. People deal with hierarchies all the time: Every day, you have a series of tasks you must prioritize and then perform. Also, most people work within a hierarchy of employees. The classic way to represent a hierarchy within a database is to add a parent key to the object. A parent key is simply the primary key of an object that has a parent relationship to the current object.

Read More
Server Side

An Ingenious Banner Rotation System

The author says: This all started when I was trying to get banner ads up to cover the hosting costs for the site. I started using a company called BurstMedia. I've been fairly happy with them overall but I also wanted more flexibility in my advertising. I looked at downloading some free banner rotation software but I didn't find anything I was excited about. Plus, none of software used the cool new way to select a random record that I'm going to cover in this article. I had three main goals for this software:

  • First, it had to be simple and easy to implement. Whenever I add a new feature to the web site I like to make it as simple as possible. I always learn so much about what I really want while I'm using the feature I hate to invest much time up front.

  • Second, it had to support advertising networks, link exchanges and serving my own ads off the site. My site is still relatively new and I'm still working on the best ways to generate revenue.

  • Finally, I wanted a solution that I could build on as I required more features. Nothing in my first requirement should make my work harder in the future. That sounds like a contradiction but I'll explain more in the article.
Read More
Server Side

Creating a Banner Rotation System

So, you want to create a banner rotation system for your website, eh? Well, you have a number of options on how to do it. If you do not need to keep track of how many times the banners are displayed, and how often they are clicked, then the simplest approach is to use Microsoft's Ad Rotator, a component that comes free with ASP! There is a great article already on 4Guys that explains how to use the Ad Rotator.

Read More
Newer articles Older articles