display image based on criteria (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

oneqw5ltr -> display image based on criteria (4/29/2008 9:32:33)

Ok... let me see if i can explain what i am trying to accomplish. I have a master crystal reporting inventory that displays on an intranet web page. When one of our report writers develop a new report we add it to this master list, which is a table in access. I would like an image (new.gif) to show up beside the report when a new report is added. So the users viewing that particular page will know that a new report has been added. I am thinking about only showing this new.gif image for reports that were added over the past 7 days. I can write a query that will show me only they reports that were added in the past 7 days, but I can't get the master list to show with only images beside the newely added reports. Any ideas?



rdouglass -> RE: display image based on criteria (4/29/2008 9:43:02)

Let's assume you have a 'reportCreationDate' field. Then we can do something like this perhaps:

<%IF DateDiff("d",rs("reportCreationDate"),Date()) < 8 Then
response.write("<img src='/images/new.gif'>")
End If%>

Something like that maybe? If that's no help, maybe you can post some of the code you're using so we can see how you're trying to do it now.

Hope it helps.



oneqw5ltr -> RE: display image based on criteria (4/29/2008 12:25:53)

That was it, beautiful!! Much appreciation!



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625