recordset error

[-D-]

I'm opening a recordset that calls a stored procedure and get the following
error: 'Operation is not allowed when the object is closed' The error is
occurring on this line at the bottom of my page. rsAlloAmts.Close() I haven't
passed in any parameters to the stored procedure when I first hit the page.
The form on the page submits to itself and passes in the values to the stored
procedure. I'm not sure what I'm doing incorrectly? Thanks, -D-

[Paul Whitham TMM]

I would check your code for another reference that is closing the database
connection prior to this line. It may well be inside of the stored procedure

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"-D-" <webforumsuser@macromedia.com> wrote in message
news:d1vc97$nve$1@forums.macromedia.com...

> I'm opening a recordset that calls a stored procedure and get the

following

> error: 'Operation is not allowed when the object is closed' The error is
> occurring on this line at the bottom of my page. rsAlloAmts.Close() I

haven't

> passed in any parameters to the stored procedure when I first hit the

page.

> The form on the page submits to itself and passes in the values to the

stored

> procedure. I'm not sure what I'm doing incorrectly? Thanks, -D-
>