Two part project for zlighting.com. 1) Add image upload (via ASPupload) and thumbnail image creation (via ASPImage) to two asp pages (forms) that populate two tables. The base pages already exist and simply need to be modified. This has already been done for one page... so you will probably simply have to follow the same format as I origionally used. Also an edit (update) option needs to be added, so users can change their information. ASPupload and ASPImage are already loaded on the server. 2) Add a "super search" page that will search (query) several tables (probably through a union query recordset)for the search word and return a formated list of links, descriptions, images. I have personally done all the modifications to date on this web site (so excuse the newbie hacking!!) but simply do not have the time (experience) to finish quickly. I expect that this whole project will only take an experience coder a few hours. This is the first (and smallest) of several enhancements that will need to be made to this site... read into this do a good job and you may get signifigant repeat business.
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. 1) Add image uploading (via AspImage) to the "add product specification" and "Add Lighting Companies" at [login to view URL] site. Current example: [login to view URL] OR [login to view URL] These revisions should be similar to the image upload seen in the "Add New Product" as seen: [login to view URL] For "product specifications" Images need to be limited to a max of 75X75 pixels (with ratio aspect) and no more than 20K in size. No thumbnails are needed for this page. For "Lighting Companies" Images need to be limited to a max of 468X60 pixels, e.g. full banner (with ratio aspect) and no more than 50K in size. No thumbnails are needed for this page. 2) An edit option needs to be added so images or data can be changed. Editing can only be accomplished by the user who added the listing (vis cookie and session variables I will supply). If a picture is changed the previous picture needs to be deleted. 3) Super search page needs to be created from scratch. This will search the "name", "keyword" and "content" fields of 5 different tables. It will return to a new page the "names" with a hyperlinks to to a detail page (based on table ID field). It will also return a value for the table that the record came from - for example, if the table name is "PIC" it will return a value of "Product Specification". It will also return a "Company" field. It will also return the first 250 characters of the "content" field. It will also return the "date" field the listing was added. It will also return the "thumbnail image" field and "image" If there is a thumbnail (not NULL) it will display it, if no thumbnail it will display the image. Revision 7/23/02 - this is six tables not 5. Structure, tables, and fields needed for union query sent seperately via this system to the four candidates. The output will appear something like Name(link) |Image goes here Table reference | " company | " date added | " The left 250 characters of the content. (carrage return) Next record There should be an option of 10, 20, or 30 record per page as seen on other search pages on the site. 3) All Code is to be well commented for future revisions by you (or others). 4) All colors an fonts are dynamic and must follow site structure/format. 5) Pages must be installed and well tested on [login to view URL] prior to payment.
## Platform
windows 2000 server with ASPImage and ASPUpload already installed. Written ASP 3.0 compliant Must work with all popular Internet browsers (3+ IE, Netscape) Currently connected to Access 2000 db. must work with this and work with MS SQL 7.0 for upgrade in very near future