Dears Sirs,
I'm not very experienced with ASP Runner and I want, if it is possible to find me a solution to my problem.
I have built a project with ASP Runner (Version 4.1 - Build225). I have built my own ASP pages for displaying my web site, but I use the ASP Runner generated pages only for importing, updating or deleting of the contents of my web site.
I have a table (Access Data Base) named photos. This table holds the following information: Photo description (text), photo small (image) and photo big (image). The ASP Runner generated pages work perfect. They can add, delete, edit, and upload images perfect with not any problem.
My problem is the following:
A sample record set of my table is like that:
Description = xxxxxxxxxxxxxxxxxxxxxx (simple text)
Photo small = xxxxxxx.jpg (image)
Photo big = zzzzzzz.jpg (image)
When a want to add a new record in my db through the ASP Runner generated pages, I use the add page and everything is ok. But sometimes maybe I will forget the names of the .jpg files, and I will add a record with the same name of the .jpg file. (For example xxxxxxx.jpg. So, at this time, 2 records have the same name of the .jpg file, but the .jpg file in the upload directory is only one. Now, if I want to delete one of the 2 records, the .jpg file will be deleted also, and I don't want that. This is my problem. I wander if there is a way, when I'm uploading a new file to have a notice that the file name that I'm trying to upload already exists in this directory, or that already exists in another record set of the same table.
Sorry for me bad English, I hope that you will understand what I'm trying to explain.
Thank you in advance,
Vasilis Dimitrakas
Athens, Greece