Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Hi im writting this code as part of my web page. The page is suppose to show teh personel details of a member. However once it gets to this code, it skips over it and goes prints the next lines. I dont know what is wrong as no error message is comming up. It just ignores the code and continues to write. The data that it is accessing is in a different table to what where the name details are.
Please help im very stuck.
The code is below.
cn9.Open "sa2,sauser,s12"'open connection
Set RsMemExp=Server.CreateObject("ADODB.Recordset") 'create a recordset
sqltext="Select Members.Memberid,ExpertiseArea.ExpertiseArea,MemberExpertise.ExpertiseAreaId FROM dbo.Members,dbo.ExpertiseArea, dbo.MemberExpertise WHERE Members.Username='varusername' AND ExpertiseArea.expertiseareaid=MemberExpertise.expertiseareaid;"
RsMemExp.Open sqltext, cn9
Do While NOT RsMemExp.EOF
' pulls out field valuep("ExpertiseArea")
Response.Write "<td width='28%' class='bold'>Area of Expertise"