Re: vbscript and oracle connection freezing.

On 16 May 2003 16:11:31 -0700, bigbinc_at_hotmail.com (bigbinc) wrote:

> 'Create an ADO recordset object
> Set rsDistance = Server.CreateObject("ADODB.Recordset")
> strSQL = "SELECT * FROM DORSEY.REHABTAB ORDER BY OBJECTID"
>
> Do While not rsDistance.EOF
>
> Response.Write rsDistance(0).Value & "<br>"
>
> Loop

 You've created a recordset, set a variable to contain a bit of SQL, but not executed it, and you then go into an infinite loop waiting for an EOF that will never arrive. You at least need to:

(a) Execute the SQL.
(b) Have a rsDistance.MoveNext statement in the loop.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)