| 1 |
SQL Random ID |
|
Description : Returns a random SQL ID |
| 2 |
SQL Random Line |
|
Description : Returns a SQL random line |
| 3 |
Delete Unwanted Email Addreses |
|
Description : A nifty script to delete unwanted or invalid
Email addresses from a database. Works with Access mdb and SQL
Server databases. |
| 4 |
Remove Duplicate Records |
|
Description : This code removes duplicate records from a
database |
| 5 |
All_Form.ASP |
|
Description : Multi-function form for basic navigation, table
editing, and recordset paging. This example includes code to
dynamically build an SQL UPDATE command based on changed items on
the current record. |
| 6 |
Common Database Routines |
|
Description : To assist in interfacing with databases. This
script can format variables and return SQL formats. Such as double
quoting apposterphies and surrounding strings with quotes, Returning
NULL for invalid d |
| 7 |
Stored Procedure Interface Generator |
|
Description : Generate the ASP code to interface with a
stored procedure |
| 8 |
Import the SQL Server error log into a table |
|
Description : To import the SQL Server error log into a
table, so that it can be queried |
| 9 |
Connection Info |
|
Description : If you want to know what drivers and other
vital details are being used for a DSN, here is some code to the
rescue |
| 10 |
Count Records |
|
Description : This script counts the records in a database.
Many people who attempt to use the .recordcount property have the
value -1 returned to them. In a nutshell, -1 means "I don't know how
many records this q |
| 11 |
Table Database Display via GetRows |
|
Description : This page demonstrates the capabilities how to
display a table from a SQL statement a very fast and scaleable way
using a recordset method called GetRows. GetRows that move many
records and fields int |
| 12 |
Database Display via GetString |
|
Description : This page demonstrates the capabilities how to
display a table from a SQL statement a very fast and scaleable way
using a recordset method called GetString. GetString essentially
asks the backend data |
| 13 |
call an Oracle Stored Procedure |
|
Description : Folks, contrary to popular belief there are
many ways to call stored procedures from an ASP page. I've tried it
with Oracle (the only REAL RDBMS ;-) and it works. |
| 14 |
Display Table, Edit Record, Update Record |
|
|
| 15 |
Database -- Convert to Comma-Delimited File |
|
Description : This page demonstrates the capabilities how to
write an ASCII comma-delimited file from a SQL statement |
| 16 |
Delete Record with SQL statement |
|
Description : SQL statements can be used to delete data as
well. |
| 17 |
RecSet Function |
|
Description : The RecSet Function returns a two-dimensional
array representing the resultant recordset of an SQL query. There
are two required arguments, connstring which must be a valid OLE
database connection str |
| 18 |
SqlExec Statement |
|
Description : The SqlExec statement executes an sql statement
that returns no records. This is primarily useful for CREATE, DROP,
INSERT, UPDATE or DELETE sql statements. There are two required
arguments: ConnStrin |
| 19 |
Tables Function |
|
Description : The Tables Function returns an array of all
table names in a database. There is one required argument,
connstring which must be a valid OLE database connection string. |
123
Eng