"Show If" don't seem to be working

[Bill]

Hi All

Has anyone ever come across a problem with your "show if record is empty"
not working. I apply it to text I want to show if record is empty and select
the appropriate recordset but when run in the browser I get famous empty
record error.

Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.
/searchlist.asp, line 132

Any ideas????

Bill

[Paul Whitham TMM]

I have generally found that the times it did not work was when I had
referenced the recordset on another part of the page, and forgot to wrap
that in its own SB

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

"Bill @gmail.com>" <bill.betournay<SpamTrap> wrote in message
news:d46vcn$3aj$1@forums.macromedia.com...

> Hi All
>
> Has anyone ever come across a problem with your "show if record is empty"
> not working. I apply it to text I want to show if record is empty and

select

> the appropriate recordset but when run in the browser I get famous empty
> record error.
>
> Error Type:
> ADODB.Recordset (0x800A0BCD)
> Either BOF or EOF is True, or the current record has been deleted.

Requested

> operation requires a current record.
> /searchlist.asp, line 132
>
> Any ideas????
>
> Bill
>
>

[Bill]

It turned out to be the connection. I've never seen this before but I had
been using a DSNless connection. As soon as I setup a ODBC connection away
it went.

BIll


"Bill @gmail.com>" <bill.betournay<SpamTrap> wrote in message
news:d46vcn$3aj$1@forums.macromedia.com...

> Hi All
>
> Has anyone ever come across a problem with your "show if record is empty"
> not working. I apply it to text I want to show if record is empty and
> select the appropriate recordset but when run in the browser I get famous
> empty record error.
>
> Error Type:
> ADODB.Recordset (0x800A0BCD)
> Either BOF or EOF is True, or the current record has been deleted.
> Requested operation requires a current record.
> /searchlist.asp, line 132
>
> Any ideas????
>
> Bill
>