Bubba
Posts: 33
|
| Posted: 08/07/2007, 11:53 PM |
|
I have a page that shows users their current membership status.
In the database I have a txt field for the status.
EG:
“U” = unfinancial
“F” = financial
I want to show a link to "U" members to ask them to resubscribe, however using the code below it does not retrieve the text that is being displayed.:
if MyDetails.Status.value = "U" then
MyDetails.Resublink.Visible= true
else
MyDetails.lblSubOk.value = "Your Membership is Valid"
end if
I have also tried:
Dim Status
Dim MemNo
MemNo = MyDetails.Member_No.Value
Status = CCDLookUp("Status","[tblMembers]","Member_No = " & Chr(34) & MemNo & Chr(34), DBConnection1)
if Status = "U" then…..
Again it does not work because it cannot retrieve the filed MyDetails.Member_No.Value from the page.
Any help would be appreciated.
|
 |
 |
Oper
Posts: 1195
|
| Posted: 08/08/2007, 6:51 AM |
|
Bubba,
Try to use same code in before show Form (its a form right?)
http://www.GlobalDevelop.com
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Bubba
Posts: 33
|
| Posted: 08/08/2007, 3:36 PM |
|
Oh sorry,
I forgot to mention that I am using this code with the "Before Show"...but thanks for the tip anyway...
|
|
|
|
|
