Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Data Empty when set filter recordset

New Here ,
May 14, 2006 May 14, 2006
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
TOPICS
Server side applications
468
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 14, 2006 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
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 01, 2006 Sep 01, 2006
LATEST
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?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines