Data View "Next" link

J

John

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
 
J

John Jansen \(MSFT\)

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.aspx?scid=kb;en-us;821959

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
John said:
Hi, I created a view in my database with a couple thousand records, no I
Click to expand...
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."
 
M

MD Websunlimited

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/Product/PagePro/pagepro.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible


John said:
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
Click to expand...
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."
 
Top