dbList readme

dbList Leggimi

'----------------------------------------------------------------------------------------
'- ASP dbList - Version 8.1 - 30 July 2005
'----------------------------------------------------------------------------------------

Griglia di database con record di modifica, eliminare, aggiungere, ricerca, filtro e l'esportazione in excel, database e di selezione della tabella pagina di navigazione, indice di campo e di ricerca nella pagina.

Questa applicazione visualizza un archivio, e la sua tabella in una pagina html con i record in esso contenuti.
Caratteristiche: archivio a scelta con la sua tabella, si può modificare, eliminare, aggiungere, esportare, filtrare e ricercare.
Lavorare con archivi MS Access, MSSQL e MySQL.

ISTALLAZIONE:

-- estrarre e salvare nella root del tuo sito con informazioni di percorso completo.
-- aprire il file "_config.asp" e modificare i dettagli di configurazione in base alle
proprie preferenze.
-- copiare la riga 
nella pagina ASP in cui si desidera visualizzare la griglia database.

CONFIGURAZIONE suggerimenti:

È necessario specificare i percorsi per i file e le immagini dblist riferita al file ASP
dove si richiama l'applicazione dblist:

Esempio 1
remotePath = Server.Mappath("/database") & "\"
strIncPath = "/dblist/"
strimgDir = "/dblist/images/"
l'albero i percorsi sono i seguenti:
Root
|_____ TuoFileInclude.asp
|_____/dblist/ (cartella dove si trovano i files di dbList)
|_____/dblist/images/ (cartella dove si trovano le immagini di dbList)
|_____/mdb-database/ (IlTuoDATABASE.mdb)

Esempio 2
remotePath = "C:\inetpub\databases\"
strIncPath = "../dblist/"
strimgDir = "../dblist/images/"
l'albero i percorsi sono i seguenti:
Root
|_____ /yoursitefilesdir/yourincludefile.asp
|_____/dblist/ (dbList files)
|_____/dblist/images/ (dbList images)
C:\inetpub\databases\ (yourdatabase.mdb)

Nell'esempio 2 il file di database è al di fuori della Root del tuo sito web HTTP.
Se il database è nella Root, come nell'esempio 1, è possibile definire il percorso con:
remotePath = "C:\inetpub\wwwroot\yourdomain\database\" (physical path)
remotePath = Server.Mappath("/database") & "\" (virtual path)
NOTE: la banca dati avrebbe dovuto avere il permesso di scrittura sul server per aggiungere, modificare ed eliminare record.

Il file zip contiene un esempio completo con due database di Access per prova

DA FARE:

-- Suggerimenti sono ben accetti !!!
-- Codici e script sono ben accetti !!!

REVISION HISTORY:

V 8.1: (thanks to users suggestions)
-- 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: (thanks to users suggestions)
-- 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!
'---------------------------------------------------------------------------------------
'- 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 parts of this script 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.
'-
'- 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 both privately and
'- commercially, 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 ask for more info or post support questions at: - http://www.livio.net
'---------------------------------------------------------------------------------------