New Scripts | ASP | Tutorials & Tips

This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a database table. It illustrates a number of useful techniques for database manipulation.

This article explains in graphics how to configure Site Server Direct Mailer, create test members and distribution lists, create template emails, and finally, create and run a Direct Mailer package to send the personalized emails to the target members.

It can really be a pain to register .DLL's on your remote servers. This article will explore how to set up a set of ASP pages to register your DLL's on NT 4. ASP source code available for download.

Using classes in ASP 3.0 we can create dynamic arrays of objects. This article presents a sample code showing how to implement a class of dynamic arrays of objects several layers deep.

This code example demonstrates how to create excel documents on your server. Using the US state info db, after reading the contents of the db instead of writing output to the browser, html text is written to the server with the .xls file extension. A link to the new document is created (in the browser) for easy navigation to the new document. The current time (server time) is also displayed to show that the excel document was created dynamically.

This article explains how to connect a Flash movie to an Access database, and use an ASP page to query the database and transfer information over to the Flash movie. It shows how to build a very simple Flash address book to demonstrate the technique. Full source code available for download.

This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. The reader is required to have a fluid understanding of both data shaping and custom Recordsets.

This article shows you how to boost the performance of your ASP Web application by improving the speed at which your browser renders your resultant HTML.

This article explains how to easily migrate HTML pages to XML using HTML Tidy and a COM Wrapper. It discusses a sample conversion of the bookmark file from HTML to XML and then into a browser-neutral tree view. Helpful for sites where a lot of information is maintained as flat HTML pages with their pages sharing similar structure. Supporting source code available for download.

This 2-page article describes how to create a Printer Friendly Page using Microsoft's XMLHTTP component along with regular expressions. It shows how to use XMLHTTP to perform an actual HTTP GET request for the page that you wish to display in a Printer Friendly format. Then, it utilizes regular expressions to pick out chunks of text that the Web page author has defined to not appear in the Printer Friendly format. A neat read highlighting the capabilities of the XMLHTTP component and regular expressions.

This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL Distributed Management Objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks.

This article discusses how to deal with various checkboxes in form via ASP. Covers: The Default No-Frills Checkbox, Checkbox With An Associated Value, Multiple Checkboxs With The Same Name, and Checkbox Which Maintains It's State.

The author writes "CoverYourASP's original database administration tool didn't look for foreign keys, and just displayed a confusing list of primary key values. Now, it's been improved with automatically generated list boxes." This tutorial explains how to turn those foreign keys into list boxes automatically.

This article explains ADO connection strings and parameters. By the end of the article you should be able to build appropriate ones on your own instead of cutting and pasting them.

This article presents an example of multiple binary file upload for Web applications using Extensible Markup Language (XML) technology, without the typical limitation of traditional file upload processing. It describes how to use Microsoft XML Parser 3.0 (MSXML) and ActiveX Data Objects (ADO) Stream objects for a new upload strategy with several benefits. No custom ASP components are required.

This is a Web-based script writer that generates an ASP code for displaying an Access or SQL Server database using user-submitted variable names and the name of the table. Copy the output code into an asp document on your web server and your db is ready to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code.

This is an example code showing how to conduct searches on a database to display hyperlinked summaries that can be clicked on to display detail data.

RSS files can be generated using Active Server Pages (ASP). It is OK for an RSS file to have a .asp suffix. In this example an RSS 0.91 file is generated, but it could easily be applied to other RSS versions. Similarly in this case the site stores its articles in a Microsoft Access database, but the database connection could be changed to reflect a Microsoft SQL Server database.

This article shows how to use an Excel file as the database for an employee photo directory. As part of the Active Server Pages application it explains how to configure the spreadsheet for online use, create recordsets from the rows of data, and perform queries and navigate using a browser.

This article presents three modular routines to access and fetch data easier with ASP. Topics include: Fetching a Recordset, An alternative to the GetConnectedRecordSet function that opens a connection, fetches a recordset, and immediately closes the connection, and Utilities for Creating Valid SQL Statements.