Hi All,

Ive got a quickie to ask.

I have a search feature which searches memberships and displays the output. There are over 5000 in total and i display them with custom paging and they can select to display 25, 50, 100, 200, 300, 500 & 1000 records per page. The only problem is the system fails when displaying large number of records.

It works all fine locally but on the live server it comes up with cannot display error msg..

I know its something to do with the amount of data store but cannt find any info on how to fix this issue

any ideas's

Tim :)

TDA

__________________
TDA

cannot display error msg is a friendly error message. Do you have "show friendly http errors turned off"?. Posting the full unfriendly error would be helpful.

FYI 5000 records isnt that many - what data store are you using?

Wind is your friend
Matt

Hi Matt,

Yes ive got error displaying in my browser. Its definately a max request issue as i works fine locally but not on a remote server and i think its something to do with the limit of a data passed in a recordset back to a client. But im not 100%.

Im using mySQL Commercial 4.1.4 and my ODBC drivers running the latest

Tim :)

TDA

;;;Yes ive got error displaying in my browser

"cannot display" error msg is a friendly error message - you dont want these type of errors. Do you have "show friendly http errors turned off"?. Posting the full unfriendly error would be helpful.

Go to tools/internet options/advanced/ scroll down and un tick "show friendly http errors" Close all active browser sessions, open a new browser and post the new un friendly error error.

What happens when you paste your query directly into mySql? Do you get the results you are looking for? what windows GUI do you use for mySql?
IMO - SQLYog is 10 times better than PHPMyAdmin


Wind is your friend
Matt