tulnetdotcom
Posts: 26
|
| Posted: 09/17/2004, 4:45 AM |
|
Hi,
My application is based on MSaccess,IIS and ASP.
I have database for admin rights.
srno, username, grantdate, expirydate, status
i want to display two different images in grid according to the value in status field.
If Status = Active image1 should be displayed
If Status = Expired image2 should be displayed.
Please help me.
Thanks
|
 |
 |
dataobjx
Posts: 181
|
| Posted: 09/17/2004, 5:45 AM |
|
The first issue of CCS Developer Magazine demonstrates this technique - and this issue is FREE.
To download your FREE issue of CCS Developer Magazine, go to http://www.dataobjx.net and register - it's free and easy.
Then click on the CCS Developer Magazine link and download the current issue and source code.
_________________
www.DataObjx.net
www.mydigitalapps.com |
 |
 |
tulnetdotcom
Posts: 26
|
| Posted: 09/17/2004, 7:35 AM |
|
Thanks for information.
But could not find solution for my problem.
Please help me.
Thanks
|
 |
 |
GeorgeS
Posts: 206
|
| Posted: 09/18/2004, 2:06 PM |
|
I think that this should work for True/False status field:
Dim status
status=CCDLookUp("status","tblUsers","user_id=" & CCGetUserID(), DByourconnection)
IF status THEN
GridName.image.Value = "image_1.jpg"
ELSE
GridName.image.Value = "image_2.jpg"
END IF
_________________
GeorgeS |
 |
 |
tulnetdotcom
Posts: 26
|
| Posted: 09/21/2004, 1:47 AM |
|
Thanks GeorgeS,
It worked for me.
Thanks for the solution.
|
 |
 |
|