Hi there, well, I know how to use this server behavior, but now I've a little problem, I've 3 documents, one to filter the results, one to show the results and the last one to show the results details, I'm filtering the first document with this statement: <b>$query_RSRestaurants = "SELECT distinct Categoria FROM restaurants";</b> so , in this document according the field ' categoria ' I choose an option, ( international, Chinese, Mexican, etc.... ), then I'll go to the results page wich is filtering the search by: <b>$query_RSInfoRestaurant = sprintf("SELECT * FROM restaurants WHERE Categoria = '%s' ORDER BY Nombre asc", $colname_RSInfoRestaurant);</b>, and this populates my document, the problem is when I insert the Recordset Paging Behavior, at the beggining works, but if I click on next shows nothing and then if I click on Back or First shows nothing too, so, where's the error?, any help?

Thanks in Advance!!!!!

Arturo

Hi all,

I am having the same problem, the recordset is populating correctly, and I can display (n) amount of records on the first page, however once I have added recordset paging and I click next to view next (n) records nothing is displayed. And again clicking previous or next nothing is displayed.

Anyone have any ideas?

Chris

no help for us?, pleaseeeee?.....

I have noticed that when I remove the WHERE clause from the SQL my recordset paging works correctly. Is it something to do with the query builder in Dreamweaver?

Please Help!!

Nop, it gives me an error from the SQL statment

<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Edited by - acivit on 27 Jun 2005 17:53:09