Skip to main content
Participant
May 14, 2006
Question

Data Empty when set filter recordset

  • May 14, 2006
  • 1 reply
  • 465 views
Dear All,

I am create dynamic page with ASP I have problem about set recordset filter.When I set filter is none in recordset dialog box the page can be show data from my database but when I set filter is field such as filter : member_id and = URL parameter is "memid" It's empty data on page when I set show region when record set Is not empty. If I don't set the page will be show error message "HTTP 500.100 - Internal Server Error - ASP error Internet Information Services Error Type:ADODB.Field (0x800A0BCD)Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."

How I solve this problem ? Please suggest me.

Best Regards,
Ms.Nisarat
This topic has been closed for replies.

1 reply

Inspiring
May 14, 2006
Hard to tell without seeing your code, but 9 times out of 10, this is
incorrect filtering. How are you requesting the data? URL parameter is
when you use a link. If you have a form involved, then you shoudl be using
Request.Form. It looks like the data is not being passed.


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development


"nisarat_kak" <webforumsuser@macromedia.com> wrote in message
news:e47a6l$r75$1@forums.macromedia.com...
> Dear All,
>
> I am create dynamic page with ASP I have problem about set recordset
> filter.When I set filter is none in recordset dialog box the page can be
> show
> data from my database but when I set filter is field such as filter :
> member_id
> and = URL parameter is "memid" It's empty data on page when I set show
> region
> when record set Is not empty. If I don't set the page will be show error
> message "HTTP 500.100 - Internal Server Error - ASP error Internet
> Information
> Services Error Type:ADODB.Field (0x800A0BCD)Either BOF or EOF is True, or
> the
> current record has been deleted. Requested operation requires a current
> record."
>
> How I solve this problem ? Please suggest me.
>
> Best Regards,
> Ms.Nisarat
>


Participant
September 1, 2006
Hey Nancy,

What if you were using the login server behavior and after successful login you filtered the recordset on the page by username / Session variable / MM_username. Is that the way you would filter the recorset to display the users details?