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: 347 Rating:
(3.10) votes 21
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: 5472 Rating:
(3.00) votes 57
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: 4737 Rating:
(2.98) votes 41
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: 4802 Rating:
(3.03) votes 38
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: 5304 Rating:
(3.00) votes 37
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: 5414 Rating:
(2.53) votes 59
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: 6423 Rating:
(3.02) votes 41
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: 5567 Rating:
(2.98) votes 41
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: 5673 Rating:
(2.96) votes 47
Database Full Cycle
Display Table, Edit Record, Update Record...Added on: 11/26/2002 Hits: 5420 Rating:
(2.96) votes 26
Delete Record with SQL statement
SQL statements can be used to delete data as well. ...Added on: 11/26/2002 Hits: 6806 Rating:
(3.00) votes 30
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: 6752 Rating:
(3.00) votes 25
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: 5688 Rating:
(3.00) votes 52
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: 6316 Rating:
(3.00) votes 31
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: 5684 Rating:
(3.09) votes 32
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: 4270 Rating:
(3.08) votes 26
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: 5324 Rating:
(3.00) votes 36
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: 6459 Rating:
(3.04) votes 51
Stored Procedure Interface Generator
Generate the ASP code to interface with a stored procedure....Added on: 11/19/2002 Hits: 4686 Rating:
(3.05) votes 84
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: 4551 Rating:
(3.06) votes 36