Diplsay User Image in Instant Messaging

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

Diplsay User Image in Instant Messaging

Author

Topic

palvin
Starting Member

2 Posts

Posted - 2005-06-22 : 10:27:56

Hello friends,

I am a new ASP developer. I am working on a website that has Instant messaging feature and retrieves data from SQL 2000. Now I have written a stored procedure that notifies any member if any other member is trying to start an instant messaging conversation. It works fine except that if I want to display the picture of the other user, it gives an error

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.

Here is the stored procedure
***********************************************
CREATE PROCEDURE sproc_IMNotice
@UID CHAR(15),
@IMID INT
AS
BEGIN
DECLARE @Username CHAR(16)
SELECT @Username=[Username] FROM UserLogin WHERE [UserID]=@UID

DECLARE @OtherUID CHAR(15)
SELECT @OtherUID=[FromID] FROM IMClients WHERE [ID]=@IMID

DECLARE @OtherUser CHAR(16)
SELECT @OtherUser=[Username] FROM UserLogin WHERE [UserID]=@OtherUID

DECLARE @IMLeft INT
SELECT @IMLeft=[IMLeft] FROM IMClients WHERE [ToID]=@UID

UPDATE IMClients
SET [IMLeft]=@IMLeft - '1'
WHERE [ToID]=@UID

UPDATE IMClients
SET [IMLeft]= '0'
WHERE [IMLeft] <= '-1'

UPDATE IMClients
SET [IMPop]= '0'
WHERE [ToID]=@UID AND [ID]=@IMID
SELECT
Pictures.PictureID,
Pictures.Approved,
Pictures.Dir,
Pictures.THEFILE,
Pictures.UserID
FROM
Pictures
WHERE [UserID]=@OtherUID

SELECT @Username AS Username, @OtherUser AS OtherUser
END
GO

*********************************************

Here is how I call the procedure in ASP

*********************************************

<%
Response.Expires = 0
Response.Expiresabsolute = Now() - 1
Response.AddHeader "pragma","no-cache"
Response.AddHeader "cache-control","private"
Response.CacheControl = "no-cache"

UID=Request("UID")
IMID=Request("IMID")

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=servername; uid=user; pwd=password"
msSQL = "Execute sproc_IMNotice '" & UID & "','" & IMID & "'"
Set ORs = Conn.execute (msSQL)
%>
<html>
<head>
<title>Incoming Instant Message!</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#000000" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#000000"

vlink="#000000" alink="#000000">
<div align="center">
<table width="300" border="0" cellspacing="0" cellpadding="0" height="510">
<tr>
<td background="images/Pre-Interface_02.gif" align="center" valign="top" height="74"><img

src="images/Pre-Interface_01.gif" width="300" height="74"></td>
</tr>
<tr>
<td background="images/Pre-Interface_02.gif" align="center" valign="middle">Greetings
<%=TRIM(ORs("Username"))%>, 
 
The follow member: <%=TRIM(ORs("OtherUser"))%> 
 <img src="http://userphotos.domain.com/<%=ORs("Dir")%>/<%=ORs("THEFILE")%>" width="66" height="82" border="0"

alt=""> Is trying to start an 
Instant Message Session 
with you. 
 
Click <a href="noticeproc.asp?UID=<%=UID%>&IMID=<%=IMID%>&Answer=1">YES</a>
to accept. 
or 
Click <a href="noticeproc.asp?UID=<%=UID%>&IMID=<%=IMID%>&Answer=0">NO</a>
to decline. 
 
After clicking YES, the Instant Conversation will begin. 
 
After clicking NO, this window will close, and <%=TRIM(ORs("OtherUser"))%>
will be notified.</td>
</tr>
</table>
</div>
</body>
</html>
<%
Set ORs = Nothing
conn.close
%>
*****************************************

Any suggestions????????

Thanks in advance

This problem occurs only when I insert the following code into SP. If I remove it, it works fine. This code displays the image(or tries to)
*****************

SELECT
Pictures.PictureID,
Pictures.Approved,
Pictures.Dir,
Pictures.THEFILE,
Pictures.UserID
FROM
Pictures
WHERE [UserID]=@OtherUID

**************

This is the code that I try to display the image. I have checked the Cloumn names but they ae fine. Do you think something is wrong in using [UserID]=@OtherUID?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-06-22 : 10:41:00

quote:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.

One of the column names is incorrect
Make sure you have used correct column name in the ASP Code

Madhivanan

Failing to plan is Planning to fail

palvin
Starting Member

2 Posts

Posted - 2005-06-22 : 10:48:27

quote:
Originally posted by madhivanan

quote:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.

One of the column names is incorrect
Make sure you have used correct column name in the ASP Code

Madhivanan

Failing to plan is Planning to fail

This problem occurs only when I insert the following code into SP. If I remove it, it works fine. This code displays the image(or tries to)
*****************

SELECT
Pictures.PictureID,
Pictures.Approved,
Pictures.Dir,
Pictures.THEFILE,
Pictures.UserID
FROM
Pictures
WHERE [UserID]=@OtherUID

**************

This is the code that I try to display the image. I have checked the Cloumn names but they ae fine. Do you think something is wrong in using [UserID]=@OtherUID?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources