When you order the registered version of ODBscript, you will also get these
useful utility scripts for free:
||SQL statement and script generator.
The ODBgen.odb script will first ask you to enter a connection string
for a database on your system (e.g., the DSN, user and password).
The script will connect to that database and show a list of all the
tables and views in the database. Click on a table and you will see a
list of all the columns in that table. You can select any of them
(or click "Select all"), and click the boxes to indicate which columns
are to be considered as part of the unique key for the table.
When you submit that form, ODBgen will create a page that has several
boxes with generated ODBscript code (forms and SQL statements) to do
various operations on the table and columns you selected:
SELECT, INSERT, UPDATE, DELETE, and keyword and query-by-example searches.
You can copy and paste these into your own script. You can also
have ODBgen automatically create a set of complete, ready-to-run scripts
for basic database maintenance: inserting rows, updating, and querying.
Just specify a directory on your site, and optionally specify custom
HTML header and footer files, and ODBgen will write the scripts to
your directory, ready to run.
||Site file manager utility.
This set of scripts implements a simple multi-user Web-based file manager function
for your site: You can give the Admin user access to your entire site,
but you can also create user accounts and assign subdirectories.
Each user can get directory listings, upload and download files, rename
files, and delete files, using only ODBscript Web pages instead of FTP.
The system also supports creating, renaming, and deleting subdirectories.
The upload function has an option to rename any existing file with the
same name to have a ".bak" entension, and there is a function to restore
the ".bak" version: When ".bak" files are found in any directory
listing, a pull-down list selection at the bottom of the page allows
restoring the original file with one click. The directory listing shows any
subdirectories with a clickable link to see the files in that subdirectory,
while all non-directory files are shown as clickable download links.