unable to display different kind of files

Hi Faisal

grt work on the tutorial. I as a complete novice could implement most of it. I am a student who has web site developer job. I did the entire thing with SQL Server 2000 and everything except the file.asp file is working. Basically the page keeps opening the same PDF file no matter which file i click on (in the show.asp page). All the IDs goto the same PDF file. I tried uploading gifs, jpegs, even txt files but it still keeps opening the same pdf file that i had loaded earlier. Pls advise as to what I shld look at/chk out.

Suhas,

I don't think you'll have to change anything in the code.

The reason you are getting the same ID for all the files on 'show.asp' is that probably the table structure you created for "Files" table lacks 'Primary Key' and 'Identity' constraints on the "ID" field of "Files" table.

So in the Enterprise Manager, set the "ID" field of "Files" table to "Primary Key" and also set it to "Identity" so that every new record inserted increments the ID field value. This way after you upload files, each file will be given a new ID unique to it.

I hope you'd have got the idea. If not please ask and I'll explain.