Re: Oracle/ASP hanging

On 25 Aug 2003 08:00:22 -0700, s_gemberling_at_yahoo.com (s_gemberling) wrote:

> set rsWorkOrders = Server.CreateObject("ADODB.Recordset")
> rsWorkOrders.CursorLocation = adUseclient
> rsWorkOrders.locktype = adLockReadOnly
> rsWorkOrders.cursortype = adOpenForwardOnly
>
> set rsWorkOrders = cmd.Execute

A subtle point, not connected to your problem, but realise that the last line above negates all the other lines above by totally replacing the object held by rsWorkOrders. Thus, you can lose those lines totally, keeping just the last line.

If you did want to create a recordset object, finesse the properties, and call the stored procedure with results into this recordset, replace the last line with:

        rsWordOrders.Open cmd

Still looking at your code....

--
Ross McKay, WebAware Pty Ltd
"Since when were you so generously inarticulate?" - Elvis Costello