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: 503 Rating:
(3.05) votes 22
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: 7530 Rating:
(3.02) votes 53
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: 6637 Rating:
(3.04) votes 53
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: 5794 Rating:
(3.10) votes 50
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: 14961 Rating:
(2.95) votes 77
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: 6814 Rating:
(2.76) votes 62
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: 4544 Rating:
(3.00) votes 42
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: 14603 Rating:
(4.05) votes 96
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: 5695 Rating:
(3.04) votes 46
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: 5329 Rating:
(3.13) votes 45
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: 5459 Rating:
(3.09) votes 53
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: 13907 Rating:
(2.98) votes 46
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: 4420 Rating:
(3.18) votes 39
Array SortAlpha
Sorts arrays alphabetically,ascending or descending. ...Added on: 12/17/2002 Hits: 6733 Rating:
(2.93) votes 43
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: 6216 Rating:
(2.94) votes 36
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: 4882 Rating:
(3.03) votes 31
Count Lines
Count lines (vbLF) in a string of every record...Added on: 11/26/2002 Hits: 5284 Rating:
(2.97) votes 31
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: 5835 Rating:
(2.98) votes 51
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: 4621 Rating:
(2.97) votes 36
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: 5288 Rating:
(3.06) votes 36