Security issues became more damageful if you're not protecting your web forms. Following example is a good idea to protect our ASP pages against SQL injection attacks. This small ASP code secures and validates all information coming from your forms.
Using SQL-DMO To Backup and Verify a Database ASP / Database Integration
This article "Using the SQL Distributed Management Objects", provided an overview of SQL-DMO. This article expands upon those concepts by showing you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.
SQL Reserved Words ASP / Database Integration
Many times people will make the mistake of naming a database field with an SQL Reserved word. This is an easy mistake to make. It's hard to remember EVERY single one. Here's a concise listing of SQL Reserved words to help you along.
Fun With Stored Procedures ASP / Database Integration
A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others ... A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates... as an added bonus, it further separates the sql statement from your asp leaving you with more readable code. So let's get on with it.
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.
Returning Month of Date in an SQL Table ASP / Date and Time
This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a 'SELECT' sql statement.
Upload - to database, or not to database? ASP / Database Integration
To database or not to database? What to do with uploaded files on server-side? This article contains performance tests of several store-file methods in server-side ASP.We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command.
Add records with sql statments ASP / Database Integration
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.
Edit records with sql statements ASP / Database Integration
Learn how to edit 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.
Getting Your Quotes Right In SQL For ASP ASP / Database Integration
It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions.
Custom Paging in ASP - Fast And Easy ASP / Scripts
This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.