ASP Image Database Samples - Remote Editing with XMLHTTP

View Sample   DBPix Site

Sample Documentation.

Overview

This sample illustrates an image database/catalog that can be remotely edited using a browser. .

System Requirements

Server
IIS 5.0 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 Control version 2.0 or later.

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. 

If the directory is located on a virtual server ensure that the MDAC virtual folders have been created in accordance with the documentation.

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
Filename Description
default.asp Displays a page of items with thumbnails. View Source
item_detail.asp Displays an item's 'detail' vew with large image. View Source
item_edit.asp Form for editing a record/image. View Source
item_submit.asp Submits changes to the database (from item_edit.asp). View Source
getimage.asp Returns an image from the database for display. View Source
get_item_atg.asp Fetches a record for editing (ADTG format). View Source
get_item_xml.asp Fetches a record for editing (XML format). View Source
adovbs.inc ADO constants include file for VBScript. View Source
config.inc Configuration file with connection strings. View Source
common.inc Common asp code (eg photo border). View Source
readme.htm This file.
viewcode.asp Utility script to view source code.
pics2k.mdb Access Database containing the data and images (Access 2000 format).
images/* Image files for the sample HTML.