asp_databases thread: Some records not showing details...please advice...
This is a multi-part message in MIME format.
------=_NextPart_000_0229_01C1EACB.C7484EF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Sir:
I have 2 asp files ( form.asp, formdetails.asp).
Contents of FORM.ASP is I loop through my records containing lists
of members. Then every member on my loop have this link: "<a
href=3Dformdetails.asp?MemID=3D" & oMemberID & "</a>. That link when
clicked is supposed to display the details on that Member ID, but when i
clicked on the link, i get an exception Error like these:
Error Type:
(0x80020009)
Exception occurred.
/flirt/flirtdetails.asp, line 66
Line 66 on my code is:
sDispMsg =3D sDispMsg & "<tr><td class=3D""stdBold"" width=3D40>Member
ID: </td><td class=3D""stdBold"">" & oMemberID & "</td></tr>"
But very strange, some members' link is working and I can view their
details but most links dont work. What went wrong with my code? Please
help, advice..Thanks!
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
CONTENTS OF FORMDETAILS.ASP
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
dim oRs
dim sDispMsg
dim oMemberID
dim oPublicID
dim sVerify
dim oHeadline
dim oProfile
dim oConn, oCmd
set oConn =3D GetDBConnection()
'This is the request on every members' link
sVerify =3D Request("MemID")
set oCmd =3D GetStoredProcedure(oConn,"tblFlirt_SPFlirtDetailsLocal")
oCmd.Parameters.Append
oCmd.CreateParameter("@nID",adInteger,adParamInput,,sVerify)
set oRs =3D oCmd.execute
set oMemberID =3D oRs("MemberID")
set oPublicID =3D oRs("PublicID")
set oHeadline =3D oRs("Headline")
set oProfile =3D oRs("ProfileSummary")
sDispMsg =3D sDispMsg & "<table border=3D1 cellpadding=3D2
cellspacing=3D0 width=3D550 style=3D""BORDER-COLLAPSE:collapse;
mso-padding-alt: 0in 5.4pt 0in 5.4pt"">"
sDispMsg =3D sDispMsg & "<tr><td class=3D""stdBold"" width=3D40>Member
ID: </td><td class=3D""stdBold"">" & oMemberID & "</td></tr>"
sDispMsg =3D sDispMsg & "<tr><td class=3D""stdBold"" width=3D40>Public
ID: </td><td class=3D""stdBold"">" & oPublicID & "</td></tr>"
sDispMsg =3D sDispMsg & "<tr><td class=3D""stdBold""
width=3D40>Headline: </td><td class=3D""stdBold"">" & oHeadling &
"</td></tr>"
sDispMsg =3D sDispMsg & "<tr><td class=3D""stdBold"" width=3D40>Profile
Summary: </td><td class=3D""stdBold"">" & oProfile & "</td></tr>"
sDispMsg =3D sDispMsg & "</table><br>"
set oCmd =3D nothing
set oMemberID =3D nothing
set oPublicID =3D nothing
set oHeadline =3D nothing
set oProfile =3D nothing
oConn.Close
set oConn =3D nothing
%>
-----------
Earljon