'----------------------------------------------------------------------------------------
'- ASP dbList - Version 9.2 - 08 august 2008
'- Copyright © 2005-2008 - Livio Siri (http://www.livio.net) - All Rights Reserved.
'----------------------------------------------------------------------------------------
Database grid with records edit, delete, add, search, filter, print and export to excel,
database and table selection, page navigation, field sort and search in page.
This application fills a sortable, pageable html table with records from a database.
Features: database and table selection, records edit, delete, add, export, filter, print and search.
Works with MS Access, MSSQL. Oracle and MySQL databases.
LICENSE:
'---------------------------------------------------------------------------------------
'- This script is free OpenSource; you can modify (at your own risk) any part of it
'- and use it both privately and commercially.
'-
'- This script is distributed in the hope that it will be useful,
'- but WITHOUT ANY WARRANTY; without even the implied warranty of
'- MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR ANY
'- OTHER WARRANTIES WHETHER EXPRESSED OR IMPLIED.
'-
'- You may use this script or parts of it in your own private work, but you may NOT
'- pass the whole or any part of it off as your own work. This program is freeware.
'- You may distribute it freely provided that all the copyright notices remain
'- untouched in the scripts and the outputted HTML. You are not allowed to:
'- republish the code without linking to its home page on Livio.net web site;
'- remove or alter the copyright information in the files;
'- providing this source in either text or project form to another site for their republishing;
'-
'- I have spent many unpaid hours in development and support this and other scripts
'- available for free from Livio.net. If you like using this script then please help support
'- the development and update of this and future scripts by a small donation. All scripts
'- published remain free and you may still use them as much as you like, the donation
'- is only a request to help me cover some of the costs involved.
'-
'- Should you make any improvements to this script, please be kind enough to let me
'- know so that i may improve mine for the rest of the people who use it. Thanks.
'-
'- You can read the complete License agreement here
'- You can ask for more info at: - http://www.livio.net/
'---------------------------------------------------------------------------------------
SUPPORT:
INSTALLATION:
-- unzip and save in the root of your site with full path info.
-- open the file "_config.asp" and edit the configuration details according to your preferences.
-- copy the line <!-- #include virtual="/dblist/_config.asp" -->
into the ASP page where you want to show the database grid.
CONFIGURATION tips:
You should specify paths for dbList files and images REFERED to the ASP file
where you call the dblist application:
Example 1
remotePath = Server.Mappath("/database") & "\"
strIncPath = "/dblist/"
strimgDir = "/dblist/images/"
the paths tree is as follow:
Root
|_____ yourincludefile.asp
|_____/dblist/ (dbList files)
|_____/dblist/images/ (dbList images)
|_____/database/ (yourdatabase.mdb)
Example 2
remotePath = "C:\inetpub\databases\"
strIncPath = "../dblist/"
strimgDir = "../dblist/images/"
the paths tree is as follow:
Root
|_____ /yoursitefilesdir/yourincludefile.asp
|_____/dblist/ (dbList files)
|_____/dblist/images/ (dbList images)
C:\inetpub\databases\ (yourdatabase.mdb)
In the example 2 the database file is outside the Root dir of your HTTP web site.
If the database is under your Root dir, as in the example 1, you can either define the path with:
remotePath = "C:\inetpub\wwwroot\yourdomain\database\" (physical path)
remotePath = Server.Mappath("/database") & "\" (virtual path)
NOTE: the database dir should have write permission on server to add, edit and delete records.
NOTE: cookies must be enabled on client.
The zip file contains a full functional example with two test Access databases
TO DO:
-- SUGGESTIONS AND DONATIONS ARE WELCOME !!!
-- Script rating on Aspin, Hotscripts and Planet-Source-Code are welcome !!!
REVISION HISTORY:
'---------------------------------------------------------------------------------------
V 9.2:
-- added support for Oracle database
-- added support for external WYSIWYG editor in memo fields
-- added database dropdown selection for MySQL and MSSQL
-- added selectable SQL Filter by column(s), with show/hide toggle button
-- added Empty/Not Empty search by column dropdown
-- modified code for W3C XHTML 1.0 and CSS validation compliance
-- more flexible search syntax (space, AND, +, OR, |, NOT, -, <>)
-- automatic search keyword(s) highlight
-- enhanced automatic primary key field(s) find for all database types
-- various bugs fixed
V 8.7:
-- added multiple record delete
-- added unique database and table view configuration
V 8.6:
-- rendering speed highly improved
-- added rendering speed measurement
-- added automated password input management for Access type psw protected databases
-- added execution of Access stored Query Procedures
-- added automated password access with cookies
-- added security warning when more than one user is working on the same database table
(to avoid wrong simultaneous editing on the same record)
-- added toggle display list of dbList online users, with whois search
-- added wrap / nowrap record text display mode
-- added vertical / horizontal record display mode
-- added toggle selection for vertical / horizontal record display mode
-- added checkbox toggle selection to show/hide column dropdown filter feature
-- added configurable databases exclusion from dropdown selection and view
-- extended search capability to special SQL characters like apex
-- fixed "800A0CB3" error when trying to connect to DB2 on Windows 2003 Server
-- fixed "80040E14" error when trying to open a table with spaces in the table name
-- fixed "80020005" Type mismatch error when updating a date field
-- fixed "No value given for one or more required parameters" error when sorting fields
-- fixed "Either BOF or EOF is True, or the current record has been deleted..." error when updating
-- fixed login error when the application files path is different from "dbList" and bLogin = True
-- fixed "no table shown in the dropdown" error when using MSSQL
-- improved user input SQL query command functionality
-- revised page layout
-- some minor bugs fixed
'---------------------------------------------------------------------------------------
V 8.1:
-- fixed "800a0bcd" error when trying to add a new record to an empty table
-- fixed wrong LCID date format, MM/DD/YYYY - DD/MM/YYYY
-- added replacement statement for <br> to VbCrLf in the grid memo fields
-- added checkboxes toggle selection to show/hide unwanted columns name and content
-- added checkbox toggle selection to show field description insthead of field name (Access only)
-- added procedure access control with password protection system
(Username=admin, Password=pass)
-- added report print feature for all filtered records
-- added single record report print feature
-- added database compact utility (Access only)
-- added toggle display of field type in the add/edit window
-- changed user input SQL query command layout
-- some minor bugs fixed
'---------------------------------------------------------------------------------------
V 7.9:
-- fixed overflow bug of memo fields on the dropdown selection
-- added support for MSSQL and MySQL database types
-- added selection between databases from a given folder (Access only)
-- added database and table dropdown selection
-- added configurable default field sort either ascending or descending
-- added configurable display of field type in the add/edit window
-- added user input SQL query command, SQL command debug window, with show/hide toggle
-- changed display method of search result when "no record found"
-- improved method for search and highlight words in page
-- improved method for search by column combined with search keyword(s)
-- enhanced method for memo-textarea add/edit with the aid of an expanded text edit window
-- X image showed in place of excluded Binary field types content
-- sorting inhibited on excluded fields type
-- some minor bugs fixed
'---------------------------------------------------------------------------------------
V 7.2: modified _config.asp, _dblist_72.asp and readme files.
-- added the capability tho hide the first column (normally the primary key field)
-- added the capability tho display the column description in place of the column name
(the column description should be edited in the database file:)
'---------------------------------------------------------------------------------------
V 7.0: First release
That's it! Easy, enjoy!
|
|
|
|