browsing hard disk

[marco vranken]

Hello,

at the moment I am defining a userfriedly interface for a database administator.
The purpose is that the database administrator can easily add pictures of
different products into the database. These pictures are somewhere situated
on the PC's hard disk. So what I want to do ...

1)display these pictures via asp in my browser
2)the new pictures must be clicked
3)when clicked, the complete pathname on the harddisk of this picture must
be inserted as a new record in my database

Are these 3 steps all possible via ASP&SQL???

I would be very greatfull!

Kind Regards, Marco Vranken

[Russ Wickstrom]

Marco:

ASP code has generally ALREADY completed its task before the browser
displays the page to you. There are some exceptions, and there is now a
technique called remote scripting that might be able to assist with what you
are trying to do.

Also, ASP code runs on the web-SERVER, not the client, so there may be
challenges there as well, but if the pictures were all in a folder (or
perhaps several folders organized by type) that were in the Web Server's
virtual directory, that limitation could be overcome.

I do not believe this can be done in a single ASP page, but here is one idea
on how to approach it:

Start with an ASP that displays a list of items in the database that do NOT
have image URLs and pass the catalog number, and product type (so that we
know which set of images to look through), in a query string to a page that
could then display a series of small images (say 100px tall or so) lined up
in rows like a stamp or photo album.

Each picture on this page would need to have an <a> tag behind it which
passed the picture's URL and the catalog number from the previous page to an
ASP that laid out a full sized picture and the catalog information from the
database for confirmation. When the user, accepted that combination, the
database update could be done and the user passed back to the first page in
this series.

In theory, this should work. The toughest part is the photo album page,
because there is a need to know what image to display, yet no EASY way to
locate the names of the images available. Maybe someone else can suggest a
way to do that...

Hope this helps,

Russ Wickstrom, MCP
PC Support Analyst
Billy Graham Evangelistic Assn
Minneapolis, MN

ph: (612) 335-1300 x2291
fx: (612) 359-7081

rwickstrom@bgea.org

---
marco vranken <marco.vranken@village.uunet.be> wrote in message
news:3984567a$1@news.devx.com...
>
> Hello,
>
> at the moment I am defining a userfriedly interface for a database
administator.
> The purpose is that the database administrator can easily add pictures of
> different products into the database. These pictures are somewhere
situated
> on the PC's hard disk. So what I want to do ...
>
> 1)display these pictures via asp in my browser
> 2)the new pictures must be clicked
> 3)when clicked, the complete pathname on the harddisk of this picture must
> be inserted as a new record in my database
>
> Are these 3 steps all possible via ASP&SQL???
>
> I would be very greatfull!
>
> Kind Regards, Marco Vranken
>