Most Popular Scripts | ASP | Tutorials & Tips | Database-related

Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

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 a sample code that combines a Database Paging and a Database Search script into one. It shows you how to perform a wilcard search on a database table and then page through the results.

Explains everything in detail you'll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download.

This is a complete tutorial on adding records to the database via ASP for beginners. Both Connection and Recordset Objects discussed. Also get an insight on 'insert' SQL statement.

In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database.

Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on.

The purpose of this article is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use SQL to enter the records into the database.

Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.

Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.

In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.

This is a comprehensive tutorial on how to incorporate SQL server 7.0/2000 databases into your ASP pages. Topics include: Installation steps, Creating SQL Server 7.0/2000 Databases, Creating SQL Server 7.0/2000 Tables, Creating SQL Server 7.0/2000 Logins, Setting SQL Server 7.0/2000 Permissions, Increasing SQL Server 7.0/2000 Performance with Indexes, and Distributed SQL Server 7.0/2000 Transactions & Queries.

Here is a quick sample of searching a DB for certain records. It's really no different then doing any other query except that you need to use wildcards. In ASP / ADO the wildcard character is %. It works the way most of us have come to expect * to work. Why is it %? I have no idea, but it is. An Access 97 version of the database is available for download.

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.

An easy way to delete duplicate data from a database such as MYSQL or MSSQL.

This tutorials based on a bit of knowledge on SQL. Sample code displays us how to get and show name of columns with values.

You can use transactions in ASP as a kind of insurance policy for your database activities, making them safer and providing better error recovery. Transactions are most useful when doing multiple actions on multiple tables. The example below shows just how easy it is to use transactions from ASP, inserting a record into a table and doing a "rollback" if there's a problem.

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passwords if you already have users' database ready.

Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.

In this short ASP source code, we will pull some data from a database and fill it into a select list. We will create a custom and dynamic output.