Records 1 to 20 of 25
ASP Script Menu Browse Category
» ADO
» Array
» Components
» Cookies
» Date/Time
» Files
» Form
» Graphics
» HTML Formatting
» Language
» Math
» Misc.
» Multimedia
» Performance
» Printing and reports
» Security
» Sessions
» SQL
» Strings
» XML
» Array
» Components
» Cookies
» Date/Time
» Files
» Form
» Graphics
» HTML Formatting
» Language
» Math
» Misc.
» Multimedia
» Performance
» Printing and reports
» Security
» Sessions
» SQL
» Strings
» XML
SQL ASP Scripts
ASP Script Home » SQL
25 ASP SQL Scripts
Sort: Most Viewed | Highest Rated | Newest
Dynamic Where Clause Using Variable
This code is a simple dynamic where clause base on the variable pass on the querystring. This is very useful in search with multiple parameter. You can view the working example in Ex-designz.net member search and member profile page....Added on: 8/23/2007 Hits: 476 Rating:
(2.90) votes 30
Simple Sorting Records
This is the code use at Ex-designz.net to sort records. What it does, it will the sort records in Highest Rated, Most Downloaded and Newest depending the user querystring selected i.e. sortdownload.asp?sid=1 will display to most downloaded. ...Added on: 2/19/2005 Hits: 5579 Rating:
(3.00) votes 62
Tables Function
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. ...Added on: 12/5/2002 Hits: 4834 Rating:
(2.92) votes 48
SqlExec Statement
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: ConnString and SQL. ConnString must be set to a valid database connection string and SQL must be se...Added on: 12/5/2002 Hits: 4895 Rating:
(2.90) votes 51
SqlExec Statement
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: ConnString and SQL. ConnString must be set to a valid database connection string and SQL must be se...Added on: 12/5/2002 Hits: 5368 Rating:
(3.20) votes 50
RecSet Function
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 string and SQL which must be an SQL statement. If no records are found, RecSet returns Null. ...Added on: 12/5/2002 Hits: 5689 Rating:
(1.62) votes 161
Recs Function
The Recs function returns a long representing the record count returned by an SQL statement. There are two required arguments: ConnString and SQL. ConnString must be set to a valid database connection string and SQL must be set to a valid SQL statement. Recs returns Null if error handling is...Added on: 12/5/2002 Hits: 6495 Rating:
(3.04) votes 52
Procs Function
The Procs Function returns an array containing the names of all procedures in a database. There is one required argument, connstring which must be a valid OLE database connection string. ...Added on: 12/5/2002 Hits: 5622 Rating:
(2.98) votes 46
GetProcedureDef Function
GetProcedureDef returns information about the arguments of a given stored procedure. It returns a reference to a Scripting.Dictionary object whose keys and items collections will be filled about data gathered from the stored procedure. GetProcedureDef is primarily useful for MS Access users ...Added on: 12/5/2002 Hits: 5726 Rating:
(2.96) votes 52
Database Full Cycle
Display Table, Edit Record, Update Record...Added on: 11/26/2002 Hits: 5524 Rating:
(2.97) votes 36
Delete Record with SQL statement
SQL statements can be used to delete data as well. ...Added on: 11/26/2002 Hits: 6904 Rating:
(2.87) votes 39
Database -- Convert to Comma-Delimited File
This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement. ...Added on: 11/26/2002 Hits: 6835 Rating:
(3.00) votes 41
Count Records
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 query/table contains". It happens since the default cursor type is AdOpenforwardonly (see b...Added on: 11/25/2002 Hits: 5755 Rating:
(3.00) votes 63
Table Database Display via GetRows
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 into a memory array. Once in the array it is accessed very fast. If you read the code closely you will ...Added on: 11/25/2002 Hits: 6388 Rating:
(3.00) votes 36
call an Oracle Stored Procedure
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. ...Added on: 11/25/2002 Hits: 5731 Rating:
(3.08) votes 37
Database Display via GetString
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 database to build a huge string instead of moving the data as rows and columns. It allows very limited s...Added on: 11/25/2002 Hits: 4327 Rating:
(3.18) votes 33
Connection Info
If you want to know what drivers and other vital details are being used for a DSN, here is some code to the rescue. ...Added on: 11/23/2002 Hits: 5379 Rating:
(3.00) votes 42
Import the SQL Server error log into a table
To import the SQL Server error log into a table, so that it can be queried ...Added on: 11/21/2002 Hits: 6523 Rating:
(3.06) votes 62
Stored Procedure Interface Generator
Generate the ASP code to interface with a stored procedure....Added on: 11/19/2002 Hits: 4810 Rating:
(3.05) votes 134
Common Database Routines
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 data types, trimming strings so they do not exceed maximum lengths. This also has some functions so t...Added on: 11/10/2002 Hits: 4617 Rating:
(3.04) votes 46