Re-directing a page to a different address based on acriteria

[Mike1500]

Hello All,

I created an update page that once the user made the necessary changes and
click the update button that record would drop-off from the record set; The
problem is when there is no record to be updated that page would show the
following error:

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.

/TEST/Untitled_4.asp, line 147


----I would like for it to go to a different page notifying the user there is
no record to be updated. Does anyone know how to perform this task? Please
help. Thanks.

[Paul Whitham TMM]

Simply wrap the display code in a "Show region is recordset is not empty"
behavior. Then you you write a message about the no records returned in
another section of the page and wrap this is in a "Show region is recordset
is empty" behavior.

--
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]

"Mike1500" <webforumsuser@macromedia.com> wrote in message
news:d5aao3$3gp$1@forums.macromedia.com...

> Hello All,
>
> I created an update page that once the user made the necessary changes

and

> click the update button that record would drop-off from the record set;

The

> problem is when there is no record to be updated that page would show the
> following error:
>
> ADODB.Field error '800a0bcd'
>
> Either BOF or EOF is True, or the current record has been deleted.

Requested

> operation requires a current record.
>
> /TEST/Untitled_4.asp, line 147
>
>
> ----I would like for it to go to a different page notifying the user

there is

> no record to be updated. Does anyone know how to perform this task? Please
> help. Thanks.
>
>