Forums
This topic is locked
next/prev links
Posted 04 Mar 2002 18:59:47
1
has voted
04 Mar 2002 18:59:47 Toomas Riim posted:
I'd like to create something similar to master/detail page. Master page have a list of objects, and when clicked it goes to a detail page and shows one object. That's nice, but the problem is now that I couldn't make next/prev links on that detail page for linking to the next or previous objects (showing on the same detail page one by one). Any simple solutions?Replies
Replied 05 Mar 2002 06:19:14
05 Mar 2002 06:19:14 Steven Tam replied:
You need a recordset on your detail page.
Replied 05 Mar 2002 10:11:48
05 Mar 2002 10:11:48 Toomas Riim replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
You need a recordset on your detail page.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
But I have a recordset on the detail page. I tell you one more time what I wanna do. There is one master page, where I put list of data taken from MySQL database. From every record on the master page you can click to a detail page where it displays only one record. Now I want that on this detail page I have next-prev links to the next or previous record, showing it on the same page. How to do that? I did insert masterdetailPHP function, but it didnt create next/prev links on the detail page. How can one navigate?
You need a recordset on your detail page.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
But I have a recordset on the detail page. I tell you one more time what I wanna do. There is one master page, where I put list of data taken from MySQL database. From every record on the master page you can click to a detail page where it displays only one record. Now I want that on this detail page I have next-prev links to the next or previous record, showing it on the same page. How to do that? I did insert masterdetailPHP function, but it didnt create next/prev links on the detail page. How can one navigate?
Replied 05 Mar 2002 20:51:41
05 Mar 2002 20:51:41 Kent Steelman replied:
You may need more explanation on the record set. First create a record set that contains the information in the master list as well as the information required in the detail list. Remember, just because it is in the record set does not mean you have to display the information.
Now copy the record set for the master page into the detail page. Again only display the records you need. Now this is key critical, both the master and the detail page record set (which should be the same) should have a unique id listed or you may recieve a "return to many rows" error message. When you place the "previous" and "next" nav buttons on the page using the server side behaviors you should be able to navigate from one record to the next within the detail section of the page. Failing this, and let me know, I can recommend some books that walk you through this very excercise.
Kent
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
You need a recordset on your detail page.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
But I have a recordset on the detail page. I tell you one more time what I wanna do. There is one master page, where I put list of data taken from MySQL database. From every record on the master page you can click to a detail page where it displays only one record. Now I want that on this detail page I have next-prev links to the next or previous record, showing it on the same page. How to do that? I did insert masterdetailPHP function, but it didnt create next/prev links on the detail page. How can one navigate?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Wm. Kent Steelman
Now copy the record set for the master page into the detail page. Again only display the records you need. Now this is key critical, both the master and the detail page record set (which should be the same) should have a unique id listed or you may recieve a "return to many rows" error message. When you place the "previous" and "next" nav buttons on the page using the server side behaviors you should be able to navigate from one record to the next within the detail section of the page. Failing this, and let me know, I can recommend some books that walk you through this very excercise.
Kent
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
You need a recordset on your detail page.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
But I have a recordset on the detail page. I tell you one more time what I wanna do. There is one master page, where I put list of data taken from MySQL database. From every record on the master page you can click to a detail page where it displays only one record. Now I want that on this detail page I have next-prev links to the next or previous record, showing it on the same page. How to do that? I did insert masterdetailPHP function, but it didnt create next/prev links on the detail page. How can one navigate?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Wm. Kent Steelman
Replied 06 Mar 2002 00:53:19
06 Mar 2002 00:53:19 scre wdanger replied:
bra its pretty simple. Open your detail page,
add a row, click in the row & then choose "insert" then "Live objects" and finally "Recordset navigation bar". Thats it
you may either choose text or image.
I hope thats what you are lookin for.
add a row, click in the row & then choose "insert" then "Live objects" and finally "Recordset navigation bar". Thats it
you may either choose text or image.
I hope thats what you are lookin for.