Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Some records not showing details...please advice...


Message #1 by "Earljon K. A. Hidalgo" <earl@p...> on Tue, 23 Apr 2002 13:35:48 +0800
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:&nbsp;</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:&nbsp;</td><td class=3D""stdBold"">" & oMemberID & "</td></tr>"
sDispMsg =3D sDispMsg & "<tr><td class=3D""stdBold"" width=3D40>Public 
ID:&nbsp;</td><td class=3D""stdBold"">" & oPublicID & "</td></tr>"
sDispMsg =3D sDispMsg & "<tr><td class=3D""stdBold"" 
width=3D40>Headline:&nbsp;</td><td class=3D""stdBold"">" & oHeadling & 
"</td></tr>"
sDispMsg =3D sDispMsg & "<tr><td class=3D""stdBold"" width=3D40>Profile 
Summary:&nbsp;</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



  Return to Index