Question
Data Empty when set filter recordset
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
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
