DSOs to display Oracle queries in HTML dataviews...

[brel]

I'm trying to use Silverstream (3.1) datasource business objects to execute large custom SELECTs on an Oracle 8i (8.1.5) server, displaying the results in an HTML dataview on a page. My SELECT is constructed by user input of criteria, and passed to a results page, where the dataview invokes the DSO with the SELECT. The results are displayed in the dataview, which has a rows-per-page limit activated and scrolling emulation ON. The user should be able to scroll down through their query results page by page.

The problem is that the data view can only ever display two pages of result rows, no matter the number of rows which should be returned by my query. Further scroll-down clicks repeatedly display the second page of rows and go no further. The view seems to fetch from the DSO only enough rows to fill two pages, whether the row-per-page limit is set to 50, 1000, whatever.

I can't find any property or method (of either the dataview class or the DSO class/interfaces) in the documentation which increases the rows available for paging by the view. Anyone had similar problems ?

Thanks in advance... [sig][/sig]

 

[Schunel]

Hi,

I've had this problem and it's certainly a bug. You have to program yourself the navigation in the HTML View !

Ciao

 

[tonedef]

I ran into this issue as well. However, we found that it is not a problem with the view but an issue of where you invoke the DSO. If you are invoking the DSO in your PageRequestBegin method it will initialize the dataset EVERY time your page is redrawn. Move the invocation to the PageLoaded method or any event driven method and the problem will be resolved.

Hope that helps

tone

 

[Schunel]

You're right, it's not a bug ! But invoke the query in the page loaded event doesn't make the data very dynamic ...

Ciao

 

[tonedef]

No it does not make it very dynamic, that is why I said "or any event driven method." This will make the data dynamic.