Creating a Server Component with Visual Basic ASP / Component Building
This article is primarily for Active Server Pages (ASP) developers who would like to take their ASP skills a step further. By bundling ASP code into server-side components, developers not only increase Visual Basic functionality and ASP speed, but also find a marvelous way to encapsulate and protect their ASP source code.
ASP Authentication Using IP Address ASP / Cookies and Sessions
This article explains how to control application access by validating the user's login and password against a database. Once validated, the IP address of the machine they are using is checked at the top of every page. What a given user can or can't do (that is, the security levels) is now handled easily.
Get Your Data Faster with a Data Cache ASP / Database Integration
Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times.
Simple Web-Database System Application ASP / Database Integration
This application is for the beginners who wonder how to build their own web database system on their own computers. I will use Microsoft FrontPage98 and Microsoft Access in the demonstration. The reader should be familiar with the RDBMS concept and know how to use Microsoft Access tool to build a local database system. They should also have the Northwind.mdb file, which is included in Microsoft Office 97.
ASP Data Access for Beginners ASP / Database Integration
The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC).
AddCriteria Simplifies SQL Queries ASP / Database Integration
The AddCriteria function (listed later) elegantly encapsulates the logic to build an SQL statement by adding optional criteria only if the user posted data for a field.
Interrogating a Stored Procedure with ADO ASP / Database Integration
This article shows how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. You may already have experience using ADOX or SQL-DMO to accomplish this, but please keep in mind that the method displayed here is meant to be simple enough that anyone with ADO experience can use it. (ADOX and SQL-DMO will be addressed later.)
Randomizing a Recordset ASP / Database Integration
Shuffling a recordset so that it can be displayed in random order is very useful when programming dynamic Web pages. A database table containing a list of supported vendors or links to advertisers may need to be displayed in a different order each time so that none complain about always being last on the list.
Recursive Functions ASP / General Development
A function that calls itself repeatedly, satisfying some condition is called a Recursive Function. Using recursion, we split a complex problem into its single simplest case. The recursive function only knows how to solve that simplest case. You'll see the difference between solving a problem iteratively and recursively later.
Using the Application Object to Improve Performance ASP / General Development
This article discusses the usage of persistence with the Application object in detail. Explains when to use Persistence, advantanges and disadvantages of using Persistence, and what types of data exchanges are targets for optimization and the benefits and disadvantages of using persistence with the Application object.
Creating PGP-Encrypted E-Mails ASP / Emailing
This article describes the installation and configuration of PGP Command Line, and the generation of PGP-encrypted e-mails from ASP
Understanding File Upload ASP / File Operations
Building an upload file mechanism on a Web server can often require using a costly DLL. Tiago Halm's article shows you how to upload a file using only Active Server Page (ASP) code and Internet Explorer.