ASP Image Database - Browser Edit/Update/Upload with XMLHTTP This sample builds on the functionality of the simple ASP Publishing samples by supporting in-browser web-based editing/updating of a remote image database.
|
Screenshots
|
|
System Requirements
Server IIS 5.0 or later (Windows 2000 or later). OLEDB 4.0 Jet drivers (MDAC 2.1 or later, 2.5 or later recommended).
The database is supplied in Access 2000 format, but Access is not required to use the sample.
Client - Viewing Any web browser.
Client - Editing Internet Explorer 4.0 or later (5.0 or later recommended). DBPix Image Control version 2.0 or later (installed automatically if not already present).
Installation
Unzip the file into a new folder on your IIS web server, ensuring that the directory structure is reproduced.
Check that the database (.mdb) file is writable by web users (for testing give 'everyone' write permissions if in doubt).
Ensure that the IIS configuration allows script access to the top-level folder.
Walkthrough
Connect to your web-server at the url corresponding to the installation drectory. A list of items is displayed, with a thumbnail and some textual data for each one. Click one of the images to display the high resolution image. Go back to the first page and click 'Edit'. On the Edit page click 'Load' to select a new image from the filesystem, then click 'submit'. You are taken back to the first page, which shows the updated item.
|
Files & Code
| File / module | | Description | | |
| default.asp | | Displays a page of items with thumbnails. | | View Code | item_detail.asp | | Displays an item's 'detail' vew with large image. | | View Code | item_edit.asp | | Form for editing a record/image. | | View Code | item_submit.asp | | Submits changes to the database (from item_edit.asp). | | View Code | getimage.asp | | Returns an image from the database for display. | | View Code | get_item_atg.asp | | Fetches a record for editing (ADTG format). | | View Code | get_item_xml.asp | | Fetches a record for editing (XML format). | | View Code | adovbs.inc | | ADO constants include file for VBScript. | | View Code | config.inc | | Configuration file with connection strings. | | View Code | common.inc | | Common asp code (eg photo border). | | View Code | readme.htm | | This file. | | |
|
|
Revision History
| Date | | Filename | | Description |
| 24 Sep 2008 | | xmlasp-v2 | | Updated to fix a connection problem on newer versions of IIS. Simplified and improved code. |
|
|
000000000000000000000000000000000000000000000000000000000000000000000 |
|