Stored Procedure call is hanging on me.. Help!!

BG12424 · Oct 29, 2002

The following code is hanging my browser and timing out. Please help. Thanks

<%@ Language=VBScript %>

<%

dim rs1
dim cmd1
dim dbConn
dim userid

userid=326 'valid userid

Set cmd1 = Server.CreateObject("ADODB.Command&quot

with cmd1
.ActiveConnection = GetConnection
.CommandText = "WVGetUserData"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("@userid",adInteger,adParamInput, ,userid)
Set rs1 = .Execute
end with

%>

<HTML>
<HEAD>
</HEAD>
<BODY>
<%
on error resume next
do while not rs1.eof
Response.Write(rs1("username&quot

)
loop
on error goto 0

set cmd1 = Nothing
set rs1 = Nothing
%>

In the common asp included file is the following function:
function GetConnection
set GetConnection = Server.CreateObject("ADODB.Connection&quot

GetConnection.Open conn_ConnectionString
end function
regards,
Brian

japes89 · Oct 29, 2002

This has happened to me before....no worries.

on error resume next
do while not rs1.eof
Response.Write(rs1("username&quot

)
rs1.MoveNext<---------- you need to add this line!!!!!
loop
on error goto 0 _______________________________________________
OutsideIntranets.com
Stop wasting time, get to work

http://www.outsideintranets.com

BG12424 · Oct 30, 2002

Thank you regards,
Brian

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Stored Procedure call is hanging on me.. Help!!

BG12424

Programmer

japes89

IS-IT--Management

BG12424

Programmer

Similar threads

Part and Inventory Search

Sponsor