Records 1 to 20 of 30
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
ADO ASP Scripts
ASP Script Home » ADO
30 ASP ADO Scripts
Sort: Most Viewed | Highest Rated | Newest
Simple SQL table join with count all
This is a simple SQL table join with count all. This is very useful if you want to display category list and count how many records belong to that category. This is the actual code I used here at Ex-designz.net....Added on: 8/13/2007 Hits: 704 Rating:
(2.93) votes 29
Display Record Of The Day
This code use the Juliandate method to display any record you want to query from the database. Working sample can be seen at www.ex-designz.net Recipe,Lyrics,Midi and Article section....Added on: 3/12/2005 Hits: 7672 Rating:
(3.02) votes 63
CSQL (revised)
This version filters out sql statements as well as html tags that could mess up the look of your site....Added on: 7/22/2003 Hits: 6747 Rating:
(2.98) votes 61
Image Display using Database
This is a very useful script for people who want to display image as per their request from the drop down menu. 1)Assuming you have a database with the following fields ->Name(image name should match with the drop down name.) ->Link(This is where you have to specify the URL of your image) I am a...Added on: 5/3/2003 Hits: 5919 Rating:
(3.09) votes 58
Connecting to Oracle 9i the ASP Way for standalone
I am here giving you both the dsn as well as the dsnless connection for Oracle 9i connection with ASP applications. A dynamic way to explore the best database and scripting language....Added on: 5/2/2003 Hits: 15674 Rating:
(2.50) votes 155
Mass Emailing using Database
Sending mass emails from your database's contact list. Sometimes we have our own contact list in our database and we would like to send them our latest product information. This is small script which helps in doing the same. Assumptions: 1)Database which has basic emailing information like...Added on: 4/18/2003 Hits: 6898 Rating:
(2.75) votes 68
Legacy Database Handling-Foxpro -PartII
I am here giving some examples for adding, deleting and updating existing records. Please check out my code for getting connected(Legacy Database Handling-Foxpro) so you can now relate to the following codes....Added on: 4/17/2003 Hits: 4597 Rating:
(2.98) votes 48
Legacy Database Handling-Foxpro
Legacy Database still exists in many offices to replace them becomes difficult so the best option is to handle the same and transfer it gradually. One of the temporary solutions would be to make it work in the new environment This is one of the solution for the people who have the old FoxPro datab...Added on: 4/10/2003 Hits: 14708 Rating:
(4.05) votes 110
Remove HTML and Format Memo Field
Function remove HTML in MEMO field and format the output.Very useful if you have i.e. "Write Review-Comments" and you don't want someone post HTML in the MEMO fields.It also format the output with linebreak. Dexter Zafra...Added on: 3/25/2003 Hits: 5759 Rating:
(3.06) votes 52
Converting a credit card string to blanks
This script was created by me when I wanted to convert the strings of credit card to blanks for security reason. this scripts convers the first 12 characters to blanks and displays the last 4. Very useful if you want to keep your database safe from hackers....Added on: 2/21/2003 Hits: 5399 Rating:
(3.02) votes 55
Display a random record
This script will pull 10 records in the database.Seaa an example on my site....Added on: 12/27/2002 Hits: 5538 Rating:
(3.15) votes 60
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: 12/19/2002 Hits: 14017 Rating:
(2.95) votes 64
Advanced SQL Query Builder
Description:This code lets visitors to your site perform complex queries. Users may choose if specific words (or phrases) must or must not match - or if they ar e optional (default)....Added on: 12/19/2002 Hits: 4501 Rating:
(3.18) votes 50
Array SortAlpha
Sorts arrays alphabetically,ascending or descending. ...Added on: 12/17/2002 Hits: 6804 Rating:
(2.94) votes 49
ProgIDInfo Object
ProgIDInfo returns information about COM objects installed on the server. ProgIDInfo is useful for determining the CLSID, typeLib, current version, dll name, path to dll, library description, etc... for one or more entered class strings. ProgIDInfo is an extremely helpful tool for administra...Added on: 11/28/2002 Hits: 6268 Rating:
(2.90) votes 42
Add New Record with ADO
This page demonstrates the capabilities how to add a record to a database using ADO instead of SQL. The script is: ...Added on: 11/26/2002 Hits: 4958 Rating:
(3.05) votes 37
Count Lines
Count lines (vbLF) in a string of every record...Added on: 11/26/2002 Hits: 5344 Rating:
(2.95) votes 37
Index Server Access via ADO
The script below demonstrates how Index Server can be accessed via ADO to do simple searches....Added on: 11/26/2002 Hits: 5889 Rating:
(2.96) votes 57
Returning Recordsets from Oracle Stored Procedures
This article is made up mostly of (complete) example code to return a recordset from an Oracle package through ADO using the Microsoft 2.5 ODBC driver. I've tried the Microsoft OLEDB driver for Oracle, and it will not work. I haven't tried the Microsoft 2.0 ODBC driver, but I don't believe it work...Added on: 11/25/2002 Hits: 4683 Rating:
(2.95) votes 42
Oracle: Recordsets from Stored Procedures using RE
For people who might be interested in the new feature of the latest OLE DB providers that allows one to return recordsets from stored procedures via ADO, here are the detailed test steps I used: ...Added on: 11/25/2002 Hits: 5349 Rating:
(3.10) votes 42