tim
|
| Posted: 08/05/2002, 8:11 PM |
|
I want to display an icon dependant on a db value. I have an Access db with a table called docs. I have store blob data in the db. I have a column called contenttype and the values look like application/vnd.ms-excel. So for this I would want to display something like excel.gif in my grid. I am using ASP w/temp and CCS. thanks
|
|
|
 |
Alex Alexapolsky
|
| Posted: 08/06/2002, 5:38 AM |
|
Hopefully this helps
http://gotocode.com/art.asp?art_id=75&
|
|
|
|
tim
|
| Posted: 08/06/2002, 9:09 AM |
|
Let me better explain. I want to do the same as the CC2 bugtrack app where the arrows are dependant on a db value. My format has change a little here it is.
1. Form page - people enter basic form elements including a file type listbox. When they submit the form It uploads the files to my db, I record basic stuff, date, time, user, file type, categroy and then contenttype and filedata (blob).
i would like to use the contenttype column to tell me what image to display but I just am not experienced enought to do it. The format is application/vnd.filetype so its impossible to make a .gif named application/vnd.filetype.gif so I had to add the listbox for filetypes on the form. I hate it because the enter word then browse and find the file and the exttension is there but I can't work around the name with a /.
So anyway I have column in my table called FileType which the user submitted from the listbox on the form. For example I have a document and the filetype is named "word". So on the grid it diplays all the info about the document including the words "word". I would like to replace the word "word" with an image name word.gif. I have a table called filetypes that the dropdown used with 3 columns , ide,filetype, filepic. I am using ccs and ASP
|
|
|
|
tim
|
| Posted: 08/06/2002, 8:03 PM |
|
I just did a work around and figured it out. thanks
|
|
|
|
|
