I think this depends on how you are handling the selection of the subset of records. Does your Direct DBMS actually bring all records back and then filter in the resultsHTML, or do you limit the database's response?
Robert -----Original Message----- From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:53 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Paged results for a Direct DBMS action Yah, I can probably rewrite the queries to run in Search Actions, I'm honestly not sure why they're set up as Direct DBMS. However, the page has a fair list of different queries in the menu & with slightly different output for each, so I was hoping to avoid rewriting them all. I suppose I could look on this as an opportunity to clean up some code; I may be able to set it up with one or two queries and use variables in the menus. :/ I didn't realize until I was messing with this that the Search Action seems to collect a fair bit of query info that the Direct DBMS Action doesn't; I'm not sure when or how it's collected, nor where it's hiding. Behind-the-scenes magic, I guess. > -----Original Message----- > From: Jim Kass [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 3:45 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Paged results for a Direct DBMS action > > > > > The DBMS Action has no knowledge about your query... and thus > it cannot get row# information or totalrows (which is used in > the manual's implementation of next/prev results). > > However, depending on how complex your DBMS Action, you can > use the Search Action with custom criteria and results... and > you can probably accomplish the same query and still use the > pre-fab next/prev code. > > Just a suggestion. > > Jim Kass > Web Developer > > -- > Forestweb: The Source for Industry Intelligence > Best Content -- Most Relevant -- Best Delivery > http://www.forestweb.com > (310) 553 - 0008 > > -----Original Message----- > From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] > Sent: Friday, December 12, 2003 1:31 PM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: Paged results for a Direct DBMS action > > > OK, I need to add next/previous paging to a webpage. This is > the results page of a direct dbms action. > > The paging in the manual doesn't work, because it is based on > having checked the "Get Total Number of Matching Rows" box in > the Results tab of the Search Action. > > The Direct DBMS Results tab doesn't have that option, I dunno why. > > Has anyone done this? > > Thanks. j > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
