New Scripts | ASP | Tutorials & Tips

This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database.

This is a short example showing how to bring data from Access to excel where further manipulation can take place.

This is a quick and easy example of how to create a random password and mail it to the person who tried to register at your site.

Here, you'll find a few example codes that allows you to save thousands of unnecessary database queries using Application variables.

This is a sample chapter from Wrox Press book 'Professional Windows DNA.' It prvides info on building web applications with VB, COM+, MSMQ, SOAP and ASP.

This tutorial, along with full source code, explains how to store such statistics as the page being viewed, the referring page, the readers IP address, browser and screen width for your site visitors.

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).

This is a brief introduction to Active Server Pages (ASP). It discusses What are Active Server Pages, What Do I Need To Use ASP Pages, and So What Can I Do With It When I've Got It.

This 2-page article discusses multiple ways to access XML data from an ASP page. This article provides some great examples and describes the techniques for developers relatively new to XML. If you're interested in learning about XML, or need to brush up on your XML skills, this article is for you.

This tutorial will show you how to give your forms a little bit more power. By making your forms self-referencing, you can open up whole new areas of functionality with your web applications.

Everyone has seen an HTTP 404 error at some point. You follow a link on a web page, and BOOM - File not found. Perhaps the author spelt it incorrectly, or the page was uploaded to the server by mistake. This tutorial'll show you how to handle this 404 error gracefully by displaying your custom error page, and send an email to yourself so the problem gets fixed.

This short tutorial demonstrates how to insert data into a SQL database using SQL statements.

This sample will demonstrate how to quickly build a simple Yahoo! style navigation bar that displays the paths a user has taken to get to a given directory, and also displays a table of links to the sub-directories of the current directory. Full source code available for download.

This article explains why you shouldn't be sprinking <% %> render blocks throughout your HTML code. It's inefficient for the server and for your users!

This step-by-step 5-page tutorial teachs you how to allow image uploads to your site, using standard HTML and off-the-shelf ASP extensions.

Web pages usually print pretty lousy. Typically, background colors are not displayed (unless you change the browser settings) and depending on site the width may be set much wider than the printer can handle on the horizontal for an 8 � page. Providing a printer friendly format adds immeasurable value for your users. This example demonstrates how to strategically place a couple of simple tautologies that will display banners and other items in the typical or �default� view and allows a link back to the same page with a querystring value that will be used to suppress everything but the db output.

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. Sample code is provided.

The browser can do a great many things, but it has a limit of 216 colors that can �safely� (without dithering or color washout) display. Fortunately, there are many ways that you can display all the color combinations in the browser safe color palette. By placing the six possible values for color (00,33,66,99,CC,FF) in an array and nesting three for next statements with values one through six a table with all the color codes will neatly be displayed in a table.

Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin� Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected.

This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records were returned from a query, and how to detect null and blank values in the data.