photo gallery

What I am trying to do is create an ASP application using a SQL or Access back-end to present the user with GUI point-and-click to upload a set of images into a cohesive photo gallery. Options would be: ## Deliverables 1. Ask user to register and holds his data in a database (SQL) Create cookie so that user does not need to register again on next visits. 2. LOCAL SELECT (browser window) first things first : offer user which one he wants to use A or B (A. multiple upload left hand pane : ActiveX control for a multiple selection of local pictures (only pictures!) right hand pane : Rendering area > VBS of JS that shows thumbnails of all pictures found in the shown folder + a checkbox + rotate possibility+add caption text continue button that uploads selected (checkbox) in one step pictures come in photo gallery that is shown in right hand pane) B. one by one upload: ask user how many pictures he wants to upload and show as many file boxes as needed. user browses and fills boxes with image files continue button that uploads pictures in one step pictures come in photo gallery (see 3) that is shown in right hand pane a checkbox per picture + rotate possibility+add caption text after each upload : user is offered possibility to go back to upload screen and upload more pictures For A and B picture properties (width & height) should be retrieved and stored in database to see LATER users can order prints (printformats read from hidden table or textfile) and order them orders are kept in cart (client and serverside) that follows user and that he easily can find when returning to side here the property checking is in order ??" pixelwidth &height are checked per ordered format (9x13 ??" 10 x 15 - ) against a table of minimum requirements (=table holds for each format the minimum pixelwidth and height) per picture a three degree qualification is shown (bad ??" good ??" excellent) 3. all images come in SQL database as BLOBS that has a link with the usertable the usertable holds these links so that user sees his proper galleries each time he comes to site [login to view URL] pictures come in a Gallery A. in a Create Gallery module + Label Gallery (text area) or B. transparently per user (user does not create nor name gallery but it is there as a list of uploaded pictures) in both cases : Upload Picture (if possible without component) Picture Caption (text area) a checkbox + rotate possibility+add caption text (Loop This Operation Until Gallery Complete, then) Save/End 2. Edit an Existing Gallery/Picture (similar options as above) 3. Delete an Existing Gallery/Picture (similar as above) The script could be a javascript running alonside the rendering script that, once the data is retrieved, immediately compares it to a table of minimum requirements per format (9x13 or 15x16 or ....) and shows a red cross if the pictures qualifies or not. ## Platform Server IIS5.0 Win2K and SQL 2000 or 7.0 Scripting : preferably VBS Clientside :IE explorer for one by one AND multiple upload ((ActiveX) and VBS) Navigator only for one by one upload