ASP Page Control

Dec 27, 2007 @ 2:15 pm.

I recently created an intranet web application, that amongst other things, displayed the company news articles. When I started to create this news application, I soon realised that I would need some sort of paging control to limit the number of articles displayed on a single page, not only to improve performance but also to give the audience a clean display of articles without endless scrolling.

There are many solutions available, all with their own benefits and drawbacks, the one I finally implemented makes use of the ADO RecordSet Object and the PageSize, CacheSize, AbsolutePage, and PageCount properties of ADO. This article illustrates the method I used. Read the rest of this entry

Tags: ADO, ASP | Categories: Software Development | 0 Comments

Encrypting Usernames and Password

Dec 15, 2007 @ 1:15 pm.

Using the MD5 and SHA1 hash functions

If you’re using a login script on your site you probably store usernames and passwords in a database for authenticating the login.

For security reasons, you should never store these as plain text but should encrypt them with a one-way hash function such as md5 or sha1.
Read the rest of this entry

Tags: ASP, Security, SQL | Categories: Software Development | 0 Comments

Finding duplicate entries in SQL databases

Dec 12, 2007 @ 2:27 pm.

Here’s a handy query for finding duplicates in a table. Read the rest of this entry

Tags: SQL | Categories: Software Development | 0 Comments