|
| |
|
|
oneqw5ltr
Posts: 61
Joined: 4/12/2004
Status: offline
 |
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
Posts: 9137
From: Biddeford, ME USA
Status: offline
|
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.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
oneqw5ltr
Posts: 61
Joined: 4/12/2004
Status: offline
|
RE: display image based on criteria - 4/29/2008 12:25:53
That was it, beautiful!! Much appreciation!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
