Hi, I created a view in my database with a couple thousand records, no I created a data view and placed it on a SPS 2003 page, and limited the number to 10 records. After I saved it, and when to the page, everything looked fine until I clicked the "Next" link to show the next 10 records. I suddenly got a message saying "An error occurred while processing the data for this request. Contact the server administrator for more information.

Please help, I've been trying to fix this for a while now, and is getting nowhere

Thank
John

Hi John,

This is actually by design. The paging works at the actual Database Server,
and when you create a View in SQL, paging doesn't work the same way anymore
as it does for just a table.

http://support.microsoft.com/default...b;en-us;821959

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <(E-Mail Removed)> wrote in message
news:94CF3651-69CD-466D-ABF8-(E-Mail Removed)...
> Hi, I created a view in my database with a couple thousand records, no I
created a data view and placed it on a SPS 2003 page, and limited the number
to 10 records. After I saved it, and when to the page, everything looked
fine until I clicked the "Next" link to show the next 10 records. I
suddenly got a message saying "An error occurred while processing the data
for this request. Contact the server administrator for more information."
>
> Please help, I've been trying to fix this for a while now, and is getting
nowhere.
>
> Thanks
> John

Hi John,

Contact the server admin so they can review the logs and see what the problem is.

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Need to protect your web pages Page Protector Pro
http://www.websunlimited.com/order/P...ro/pagepro.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible


"John" <(E-Mail Removed)> wrote in message news:94CF3651-69CD-466D-ABF8-(E-Mail Removed)...
> Hi, I created a view in my database with a couple thousand records, no I created a data view and placed it on a SPS 2003 page, and
limited the number to 10 records. After I saved it, and when to the page, everything looked fine until I clicked the "Next" link to
show the next 10 records. I suddenly got a message saying "An error occurred while processing the data for this request. Contact
the server administrator for more information."
>
> Please help, I've been trying to fix this for a while now, and is getting nowhere.
>
> Thanks
> John